VLOOKUP - 0 instead of # N/A

J

Jaleel

Hi,

=VLOOKUP(G3,A:D,4,FALSE)

When I put the above formula, if the lookup_value is not available in the
table_array #N/A appears in the result. How can I modify the formula to get
the result as 0 instead of #N/A?

Can anybody help?

Jaleel
 
G

Gary Keramidas

this may do what you want

=IF(ISNA(VLOOKUP(G3,A:D,4,FALSE)),0,VLOOKUP(G3,A:D,4,FALSE))
 

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


Top