simple lookup

M

Max_power

Hello,

I'm trying to do a simple Vlookup that will return the number or retur
"not found" if not found. So if it's nan it will return "not found".
I can't seem to get my if statement correct


Many thank
 
G

Gizmo63

Hi,

If a lookup is not found you will get a #N/A error value, you need to test
the lookup for an error then define the answer in case of an error.

Assuming your basic lookup is fine you need:

=IF(ISNA([your lookup formula]),"Not Found",[your lookup formula])

HTH

Giz
 
Top