If-VLookup

  • Thread starter Thread starter lacosta
  • Start date Start date
L

lacosta

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")
 
Try using the ISERROR function over the VLOOKUP, something like this:

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