Hello,

I'm trying to do a simple Vlookup that will return the number or return
"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 thanks


--
Max_power
------------------------------------------------------------------------
Max_power's Profile: http://www.excelforum.com/member.php...o&userid=32255
View this thread: http://www.excelforum.com/showthread...hreadid=534891

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" wrote:


Hello,

I'm trying to do a simple Vlookup that will return the number or return
"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 thanks


--
Max_power
------------------------------------------------------------------------
Max_power's Profile: http://www.excelforum.com/member.php...o&userid=32255
View this thread: http://www.excelforum.com/showthread...hreadid=534891

Hi Max

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

Regards,
Bondi

Many thanks to both replies


--
Max_power
------------------------------------------------------------------------
Max_power's Profile: http://www.excelforum.com/member.php...o&userid=32255
View this thread: http://www.excelforum.com/showthread...hreadid=534891