Vertical Lookup Question
 

Good day, I have a quick question. When using a vertical lookup that looks
at a named table for the returned values, if the item is not present in the
table it returns an N/A. Is there any way to have it return a zero (0) if it
is not present in the table?

Vertical Lookup Question
 

You might try:-

=IF(ISNA(VLOOKUP(368.59,myrange,2,FALSE)),"0",VLOO KUP(368.59,myrange,2,FALSE))

Mike

"Jennifer" wrote:

Good day, I have a quick question. When using a vertical lookup that looks
at a named table for the returned values, if the item is not present in the
table it returns an N/A. Is there any way to have it return a zero (0) if it
is not present in the table?

Vertical Lookup Question
 

try
IF(ISNA(yourformula)),0,yourformula)
or
IF(ISNA(yourformula)),"",yourformula)

--
Don Guillett
SalesAid Software

"Jennifer" wrote in message
...
Good day, I have a quick question. When using a vertical lookup that
looks
at a named table for the returned values, if the item is not present in
the
table it returns an N/A. Is there any way to have it return a zero (0) if
it
is not present in the table?

Vertical Lookup Question
 

Thank you for the quick reponse... can you tell me what the 368.59 is?

"Mike H" wrote:

You might try:-

=IF(ISNA(VLOOKUP(368.59,myrange,2,FALSE)),"0",VLOO KUP(368.59,myrange,2,FALSE))

Mike

"Jennifer" wrote:

Good day, I have a quick question. When using a vertical lookup that looks
at a named table for the returned values, if the item is not present in the
table it returns an N/A. Is there any way to have it return a zero (0) if it
is not present in the table?

Vertical Lookup Question
 

u can use IF()&ISERROR()orISNA() to reture to zero when lookup() function
returns an N/A
i.e =IF(iserror(lookup()),0,lookup())

"Jennifer" ...
Good day, I have a quick question. When using a vertical lookup that
looks
at a named table for the returned values, if the item is not present in
the
table it returns an N/A. Is there any way to have it return a zero (0) if
it
is not present in the table?

Vertical Lookup Question
 

Thanks Don, that worked great! Strongly appreciate your help!

"Don Guillett" wrote:

try
IF(ISNA(yourformula)),0,yourformula)
or
IF(ISNA(yourformula)),"",yourformula)

--
Don Guillett
SalesAid Software

"Jennifer" wrote in message
...
Good day, I have a quick question. When using a vertical lookup that
looks
at a named table for the returned values, if the item is not present in
the
table it returns an N/A. Is there any way to have it return a zero (0) if
it
is not present in the table?

Vertical Lookup Question
 

Jennifer,

It's just happened to be a value I had in a named range to test the formula.
It's the lookup value.

Mike

"Jennifer" wrote:

Thank you for the quick reponse... can you tell me what the 368.59 is?

"Mike H" wrote:

You might try:-

=IF(ISNA(VLOOKUP(368.59,myrange,2,FALSE)),"0",VLOO KUP(368.59,myrange,2,FALSE))

Mike

"Jennifer" wrote:

Good day, I have a quick question. When using a vertical lookup that looks
at a named table for the returned values, if the item is not present in the
table it returns an N/A. Is there any way to have it return a zero (0) if it
is not present in the table?

Vertical Lookup Question
 

glad to help

--
Don Guillett
SalesAid Software

"Jennifer" wrote in message
...
Thanks Don, that worked great! Strongly appreciate your help!

"Don Guillett" wrote:

try
IF(ISNA(yourformula)),0,yourformula)
or
IF(ISNA(yourformula)),"",yourformula)

--
Don Guillett
SalesAid Software

"Jennifer" wrote in message
...
Good day, I have a quick question. When using a vertical lookup that
looks
at a named table for the returned values, if the item is not present in
the
table it returns an N/A. Is there any way to have it return a zero (0)
if
it
is not present in the table?