software

Hello,

I'm trying to do a simple Vlookup that will return the number or return
quot;not foundquot; if not found. So if it's nan it will return quot;not foundquot;.
I can't seem to get my if statement correctMany thanks--
Max_power
------------------------------------------------------------------------
Max_power's Profile: www.excelforum.com/member.php...oamp;userid=32255
View this thread: www.excelforum.com/showthread...hreadid=534891Hi Max

=IF(ISERROR(VLOOKUP()),quot;Not Foundquot;,VLOOKUP())

Regards,
BondiHi,

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]),quot;Not Foundquot;,[your lookup formula])

HTH

Giz

quot;Max_powerquot; wrote:

gt;
gt; Hello,
gt;
gt; I'm trying to do a simple Vlookup that will return the number or return
gt; quot;not foundquot; if not found. So if it's nan it will return quot;not foundquot;.
gt; I can't seem to get my if statement correct
gt;
gt;
gt; Many thanks
gt;
gt;
gt; --
gt; Max_power
gt; ------------------------------------------------------------------------
gt; Max_power's Profile: www.excelforum.com/member.php...oamp;userid=32255
gt; View this thread: www.excelforum.com/showthread...hreadid=534891
gt;
gt;


Many thanks to both replies--
Max_power
------------------------------------------------------------------------
Max_power's Profile: www.excelforum.com/member.php...oamp;userid=32255
View this thread: www.excelforum.com/showthread...hreadid=534891