Change #N/A

[Guest]

I am using Vlookup in a number of Cells and reporting #N/A when a match is not found. I would like to use an "if" statement to move to the next level of vlookup. Example
Vlookup A returns a value of ABC in "C3" and an #N/A in "C4" I would like to Set "D3 " and "D4" with a statement like
IF c3=#N/A Vlookup x,y,z else vlookup a,b,c. I can do it with "N/A" however not with "#N/A"
Any sugestions?

 

[hans]

Hi

Try something like IF(ISNA(x,y,z), (a,b,c)). You might
have a look at the IS Functions in Help.

regards
Hans

-----Original Message-----
I am using Vlookup in a number of Cells and reporting

#N/A when a match is not found. I would like to use
an "if" statement to move to the next level of vlookup.
Example:

Vlookup A returns a value of ABC in "C3" and an #N/A

in "C4" I would like to Set "D3 " and "D4" with a
statement like:

IF c3=#N/A Vlookup x,y,z else vlookup a,b,c. I can do

it with "N/A" however not with "#N/A".

 

[Bernie Deitrick]

John,

Use

=IF(ISERROR(C3), ....,.....)

HTH,
Bernie
MS Excel MVP

I am using Vlookup in a number of Cells and reporting #N/A when a match is

not found. I would like to use an "if" statement to move to the next level
of vlookup. Example:

Vlookup A returns a value of ABC in "C3" and an #N/A in "C4" I would like

to Set "D3 " and "D4" with a statement like: