Prev: Nested If Statements
Next: Sum with 2 if's
From: PAL on 6 May 2010 16:24
Can someone advise why this formula returns a "0" and not a blank?

=IF(ISERROR(VLOOKUP(A2,Rawdata,13,FALSE)),"",VLOOKUP(A2,Rawdata,13,FALSE))

Thanks.
From: Bernard Liengme on 6 May 2010 16:45
Gives a blank for me
Maybe column 13 of Rawdata is empty
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"PAL" <PAL(a)discussions.microsoft.com> wrote in message
news:548687C2-6549-4F10-9196-D56A3FA20762(a)microsoft.com...
> Can someone advise why this formula returns a "0" and not a blank?
>
> =IF(ISERROR(VLOOKUP(A2,Rawdata,13,FALSE)),"",VLOOKUP(A2,Rawdata,13,FALSE))
>
> Thanks.

From: Fred Smith on 6 May 2010 19:13
Because column 13 of Rawdata, row that has A2 in it, is zero or blank.

Regards,
Fred

"PAL" <PAL(a)discussions.microsoft.com> wrote in message
news:548687C2-6549-4F10-9196-D56A3FA20762(a)microsoft.com...
> Can someone advise why this formula returns a "0" and not a blank?
>
> =IF(ISERROR(VLOOKUP(A2,Rawdata,13,FALSE)),"",VLOOKUP(A2,Rawdata,13,FALSE))
>
> Thanks.

From: Satti Charvak on 7 May 2010 03:28
change the formula to
=IF(ISERROR(VLOOKUP(A2,rawdata,13,FALSE)),"",TEXT(VLOOKUP(A2,rawdata,13,FALSE),""))

basically when the formula is true it i" s returning an integer value from
the "rawdata" range. also you can try changing the cell format to general
also.


--
Kind Regards,
Satti Charvak
Only an Excel Enthusiast


"PAL" wrote:

> Can someone advise why this formula returns a "0" and not a blank?
>
> =IF(ISERROR(VLOOKUP(A2,Rawdata,13,FALSE)),"",VLOOKUP(A2,Rawdata,13,FALSE))
>
> Thanks.
 | 
Pages: 1
Prev: Nested If Statements
Next: Sum with 2 if's