Thread
:
Keep getting #NA
View Single Post
#
1
Posted to microsoft.public.excel.worksheet.functions
roxiemayfield
external usenet poster
Posts: 21
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)
Reply With Quote
roxiemayfield
View Public Profile
Find all posts by roxiemayfield