If-VLookup
 

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 "Good" in the cell.

The formula below is putting "Good" 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),"Good")


--
lacosta
------------------------------------------------------------------------
lacosta's Profile: http://www.excelforum.com/member.php...o&userid=15519
View this thread: http://www.excelforum.com/showthread...hreadid=518810

If-VLookup
 

=IF(ISNA(YourLookupFormula),"","Good")

--
Kind regards,

Niek Otten


"lacosta" wrote in
message ...

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 "Good" in the cell.

The formula below is putting "Good" 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),"Good")


--
lacosta
------------------------------------------------------------------------
lacosta's Profile:
http://www.excelforum.com/member.php...o&userid=15519
View this thread: http://www.excelforum.com/showthread...hreadid=518810

If-VLookup
 

Try using the ISERROR function over the VLOOKUP, something like this:

IF(ISERROR(VLOOKUP(A1829,'MAP Inbox'!$1:$65536,1,FALSE),"Bad","Good")

--
It is nice to be important, but it is more important to be nice


"lacosta" wrote:


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 "Good" in the cell.

The formula below is putting "Good" 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),"Good")


--
lacosta
------------------------------------------------------------------------
lacosta's Profile: http://www.excelforum.com/member.php...o&userid=15519
View this thread: http://www.excelforum.com/showthread...hreadid=518810

If-VLookup
 

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

Thanks.


--
lacosta
------------------------------------------------------------------------
lacosta's Profile: http://www.excelforum.com/member.php...o&userid=15519
View this thread: http://www.excelforum.com/showthread...hreadid=518810

If-VLookup
 

They really should work. You changed your formula: please post it

--
Kind regards,

Niek Otten

"lacosta" wrote in
message ...

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

Thanks.


--
lacosta
------------------------------------------------------------------------
lacosta's Profile:
http://www.excelforum.com/member.php...o&userid=15519
View this thread: http://www.excelforum.com/showthread...hreadid=518810