software

Hello,

I have an If Vlookup formula where If the VLookup item is not found or
results in an N/A then leave the cell blank. If it finds what its
looking for then put the word quot;Goodquot; in the cell.

The formula below is putting quot;Goodquot; when it finds a good result and N/A
when it doesn't find the match.

Please help. I have tried over a dozen things but nothing worked.

IF(VLOOKUP(A1829,'MAP Inbox'!$1:$65536,1,FALSE),quot;Goodquot;)--
lacosta
------------------------------------------------------------------------
lacosta's Profile: www.excelforum.com/member.php...oamp;userid=15519
View this thread: www.excelforum.com/showthread...hreadid=518810=IF(ISNA(YourLookupFormula),quot;quot;,quot;Goodquot;)

--
Kind regards,

Niek Ottenquot;lacostaquot; gt; wrote in
message ...
gt;
gt; Hello,
gt;
gt; I have an If Vlookup formula where If the VLookup item is not found or
gt; results in an N/A then leave the cell blank. If it finds what its
gt; looking for then put the word quot;Goodquot; in the cell.
gt;
gt; The formula below is putting quot;Goodquot; when it finds a good result and N/A
gt; when it doesn't find the match.
gt;
gt; Please help. I have tried over a dozen things but nothing worked.
gt;
gt; IF(VLOOKUP(A1829,'MAP Inbox'!$1:$65536,1,FALSE),quot;Goodquot;)
gt;
gt;
gt; --
gt; lacosta
gt; ------------------------------------------------------------------------
gt; lacosta's Profile:
gt; www.excelforum.com/member.php...oamp;userid=15519
gt; View this thread: www.excelforum.com/showthread...hreadid=518810
gt;
Try using the ISERROR function over the VLOOKUP, something like this:

IF(ISERROR(VLOOKUP(A1829,'MAP Inbox'!$1:$65536,1,FALSE),quot;Badquot;,quot;Goodquot;)

--
It is nice to be important, but it is more important to be nicequot;lacostaquot; wrote:

gt;
gt; Hello,
gt;
gt; I have an If Vlookup formula where If the VLookup item is not found or
gt; results in an N/A then leave the cell blank. If it finds what its
gt; looking for then put the word quot;Goodquot; in the cell.
gt;
gt; The formula below is putting quot;Goodquot; when it finds a good result and N/A
gt; when it doesn't find the match.
gt;
gt; Please help. I have tried over a dozen things but nothing worked.
gt;
gt; IF(VLOOKUP(A1829,'MAP Inbox'!$1:$65536,1,FALSE),quot;Goodquot;)
gt;
gt;
gt; --
gt; lacosta
gt; ------------------------------------------------------------------------
gt; lacosta's Profile: www.excelforum.com/member.php...oamp;userid=15519
gt; View this thread: www.excelforum.com/showthread...hreadid=518810
gt;
gt;


The two suggestions below are still not working for me. What else can I
do?

Thanks.--
lacosta
------------------------------------------------------------------------
lacosta's Profile: www.excelforum.com/member.php...oamp;userid=15519
View this thread: www.excelforum.com/showthread...hreadid=518810They really should work. You changed your formula: please post it

--
Kind regards,

Niek Otten

quot;lacostaquot; gt; wrote in
message ...
gt;
gt; The two suggestions below are still not working for me. What else can I
gt; do?
gt;
gt; Thanks.
gt;
gt;
gt; --
gt; lacosta
gt; ------------------------------------------------------------------------
gt; lacosta's Profile:
gt; www.excelforum.com/member.php...oamp;userid=15519
gt; View this thread: www.excelforum.com/showthread...hreadid=518810
gt;