View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
roxiemayfield roxiemayfield is offline
external usenet poster
 
Posts: 21
Default Keep getting #NA

Hi,

I have the following formula that I am having trouble with. If the lookup is
blank I would like the value to be 0. It keeps coming back #NA. What do I do
now?

Thank you for your help.

=VLOOKUP($B13,pmp3w1,3,FALSE)