VLOOKUP IS ERROR
 

Can someone advise why this formula returns a "0" and not a blank?

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

Thanks.

VLOOKUP IS ERROR
 

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" wrote in message
...
Can someone advise why this formula returns a "0" and not a blank?

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

Thanks.

VLOOKUP IS ERROR
 

Because column 13 of Rawdata, row that has A2 in it, is zero or blank.

Regards,
Fred

"PAL" wrote in message
...
Can someone advise why this formula returns a "0" and not a blank?

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

Thanks.

VLOOKUP IS ERROR
 

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)),"",VLOOK UP(A2,Rawdata,13,FALSE))

Thanks.