simple lookup

[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

 

[Bondi]

Hi Max

=IF(ISERROR(VLOOKUP()),"Not Found",VLOOKUP())

Regards,
Bondi

 

[Guest]

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

 

[Max_power]

Many thanks to both replies