Can I turn the #N/A result from a lookup function to a zero?

  • Thread starter Thread starter Guest
  • Start date Start date
=IF(ISNA(VLOOKUP(A1,C1:D100,2,FALSE)),0,VLOOKUP(A1,C1:D100,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 function yielding a #N/A result 6
Lookup returning wrong results 0
#N/A in lookup function 3
#N/A Error w/LOOKUP Function 6
First row where a cell is zero 1
What can I add to a vlookup formula to give me a 0 not #n/a 4
Vlookup and #N/A result 4
Trapping errors in a VLOOKUP function 1

Back
Top