How Do I Compare one cell to an Entire Column

E

ExcelAlex

I have a workbook that imports data from two separate text files. I wan
to find any matches between the two sets of data, but they will not b
in the same order.

IF
Cell in Column 1 (from data import 1) = Any Cell in Column 2 (from dat
import 2)
THEN
Column 3 = "MATCH"

I'd like to do this for every cell in column 1. The lists can up t
1000 rows long.

If anyone out there can help me, I'd greatly appreciate it!

THANKS!
Ale
 
I

icestationzbra

if column A as a, s, x, y and column B has a, s, d, f; put this formul
in C1 and drag down.

=IF((COUNTIF($B$1:$B$4,A1)>0),"Match",A1)

check it this helps
 
Top