Take the 2-minute tour ×

I am trying to see 1) if a cell value in excel matches another cell in a table and 2) For the matching cells, enter corresponding information from the table . I came up with the following formula, but it doesn't work: IF(OR(EXACT(A2,$O$2:$O$467)),VLOOKUP(O2,O2:S2,4),"")

Can someone please tell me what i'm doing wrong?

share|improve this question
add comment

1 Answer

Adding "FALSE" as the 4th parameter in the VLOOKUP function will return data only for an exact match.


(Note: IFERROR only works in Excel 2007 and later. If you are using an earlier version you can use =IF(ISERROR(VLOOKUP(O2,O2:S2,4,FALSE)),"",VLOOKUP(O2,O2:S2,4,FALSE)).)

This will not work if you are looking for a case-sensitive match.

share|improve this answer
Here's some information about performing case-sensitive lookups: support.microsoft.com/kb/214264 –  Excellll Aug 7 '11 at 15:34
FYI Microsoft's solution is really weak. It can't find "Joe" in a table if it is preceded by "joe". –  Excellll Aug 7 '11 at 15:40
add comment

Your Answer


