View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
 
Posts: 2,389
Default 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.