Matching Data Two Columns

[malavp552]

Hello,

I was given a task to find matches between 2 sets of addresses. I have the information in 2 columns side by side and the first column has the addresses I want to find in the second column. The first column has 214 entries and the second has 1314. What formula can I use to compare the two columns and find the matches within them?

Thanks,
Malav

[TMS]

You could probably use COUNTIF to check if an entry in one list is in the other list.

[alansidman]

Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file.

[menem]

You may use MATCH to find the exact match from column 1 and 2.

for sample in C1 (third column as a result of row of column 2)

=Match(A1,B:B,0)

Regards.