# VLOOKUP - 0 instead of # N/A

J

#### 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

J

#### Jacob Skaria

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

G

#### Gary Keramidas

this may do what you want

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

J

#### Jaleel

Jacob,

Sorry, it is not working.

Jaleel

Jacob Skaria said:
Try
=IF(ISNA(VLOOKUP(G3,A,4,FALSE)),0,VLOOKUP(G3,A,4,FALSE))

J

#### Jacob Skaria

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

J

#### Jaleel

Jacob,

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

Regards,

Jaleel

T

#### T. Valko

Here's another one...

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

J

#### Jaleel

Valko,

Wonderful!

Regards,

Jaleel

T. Valko said:
Here's another one...

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

--
Biff
Microsoft Excel MVP

.