VLOOKUP IS ERROR

  • Thread starter Thread starter PAL
  • Start date Start date
P

PAL

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.
 
Because column 13 of Rawdata, row that has A2 in it, is zero or blank.

Regards,
Fred
 
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.
 
Back
Top