Thread: VLOOKUP IS ERROR
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PAL PAL is offline
external usenet poster
  
Posts: 200
Default 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.
Reply With QuoteReply With Quote