simple lookup

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

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