VLOOKUP #N/A

F

Frank Kabel

Hi
one way:
=IF(ISNA(VLOOKUP(...)),"",VLOOKUP(...))
-----Original Message-----
I have a Vlookup function = (VLOOKUP
Click to expand...
("DDW",paymentplans,2,FALSE).This works well, but if a
reference in the table cannot be found - for example DDW
as in the above example, it returns #N/R. How Can I avoid
this, as it is part of an =SUM()formula??
 

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

VLOOKUP #N/A 0
Help With VLOOKUP 2
VLOOKUP #N/A 0
Same forumula returns both 0 & N/A 2
vlookup formatting problem 1
Can I add a formula or function to Vlookup? 1
VLOOKUP & Data Validation 0
Vlookup Returning Zero For Every Cell 3

Top