VLOOKUP - 0 instead of # N/A
 

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

VLOOKUP - 0 instead of # N/A
 

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

--
Jacob


"Jaleel" wrote:

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

VLOOKUP - 0 instead of # N/A
 

this may do what you want

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

--


Gary Keramidas
Excel 2003


"Jaleel" wrote in message
...
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

VLOOKUP - 0 instead of # N/A
 

Jacob,

Sorry, it is not working.

Jaleel

"Jacob Skaria" wrote:

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

--
Jacob


"Jaleel" wrote:

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

VLOOKUP - 0 instead of # N/A
 

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

--
Jacob


"Jaleel" wrote:

Jacob,

Sorry, it is not working.

Jaleel

"Jacob Skaria" wrote:

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

--
Jacob


"Jaleel" wrote:

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

VLOOKUP - 0 instead of # N/A
 

Jacob,

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

Regards,

Jaleel

"Jacob Skaria" wrote:

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

--
Jacob


"Jaleel" wrote:

Jacob,

Sorry, it is not working.

Jaleel

"Jacob Skaria" wrote:

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

--
Jacob


"Jaleel" wrote:

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

VLOOKUP - 0 instead of # N/A
 

There's a quick snippet on error handling here
http://tinyurl.com/ydvv3b8

Jaleel;582731 Wrote:
Jacob,

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

Regards,

Jaleel

"Jacob Skaria" wrote:

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

--
Jacob


"Jaleel" wrote:

Jacob,

Sorry, it is not working.

Jaleel

"Jacob Skaria" wrote:

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

--
Jacob


"Jaleel" wrote:

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


--
Simon Lloyd

Regards,
Simon Lloyd
'Microsoft Office Help' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: 1
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=161264

Microsoft Office Help

VLOOKUP - 0 instead of # N/A
 

Here's another one...

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

--
Biff
Microsoft Excel MVP


"Jaleel" wrote in message
...
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

VLOOKUP - 0 instead of # N/A
 

Valko,

Wonderful!

Regards,

Jaleel

"T. Valko" wrote:

Here's another one...

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

--
Biff
Microsoft Excel MVP


"Jaleel" wrote in message
...
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


.

VLOOKUP - 0 instead of # N/A
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Jaleel" wrote in message
...
Valko,

Wonderful!

Regards,

Jaleel

"T. Valko" wrote:

Here's another one...

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

--
Biff
Microsoft Excel MVP


"Jaleel" wrote in message
...
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


.