#N/A in vlookup


G

Guest

How to fix #N/A if vlookup can't find a match to the lookup value.

For example,

Array = D1:E2
D1:E2 =
Apple 1
Orange 2

Lookup value = A1
A1 = Pear

vlookup(A1, D1:E2, 2,0)

Result will return as #N/A since "Pear" cannot be found in the array.

Question: how do I set it to blank or 0 if it's #N/A?

Please help! Thank you.
 
Ad

Advertisements

B

Bernard Liengme

Try =IF(ISNA(vlookup(A1, D1:E2, 2,0)),"not found", vlookup(A1, D1:E2, 2,0))
best wishes
 
Ad

Advertisements


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

Top