Lookup table returns #N/A

  • Thread starter Thread starter Kimberly Bassininsky
  • Start date Start date
K

Kimberly Bassininsky

I have am using a lookup formula that when there is no exact match it
returns "#n/a". I want it to return either a zero or remain blank if there
is no match. I know there is a way to change my lookup formula to
accomplish this but I can remember how.

Any help would be appreciated.

Thanks,
Kim
 
=IF(ISNA(VLOOKUP(A1,H1:I1000,2,FALSE)),"Zero, blank or error
message",VLOOKUP(A1,H1:I1000,2,FALSE))
Regards,
Alan.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Lookup returning #n/a 1
Compare Value in Cell 1 to a List, Return Value if Match otherwise Return Null 2
Formula returns #N/A 1
Converting to Number for V Lookup 6
Look up a reference which has more than 1 exact match 1
Return 0 instead of N/A 2
Lookup Question 4
Case Sensitive v-lookup needed 3

Back
Top