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.
|