VLOOKUP - 0 instead of # N/A

[Jaleel]

Hi,

=VLOOKUP(G3,A,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

 

[Jacob Skaria]

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

 

[Gary Keramidas]

this may do what you want

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

 

[Jaleel]

Jacob,

Sorry, it is not working.

Jaleel

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

 

[Jacob Skaria]

Make sure the cell references are correct and try again..

 

[Jaleel]

Jacob,

You are right. My cell references were wrong. Thanks a lot.

Regards,

Jaleel

 

[T. Valko]

Here's another one...

=IF(COUNTIF(A:A,G3),VLOOKUP(G3,A,4,0),0)

 

[Jaleel]

Valko,

Wonderful!

Regards,

Jaleel

Here's another one...

=IF(COUNTIF(A:A,G3),VLOOKUP(G3,A,4,0),0)

--
Biff
Microsoft Excel MVP





.

 

[T. Valko]

You're welcome. Thanks for the feedback!