Matching 2 columns in Excel Solved/Closed

Question

Hello, I've got 2 columns of data- I'm trying to see if there's a match between the data in Column A with Column B- if the data is in Column B somewhere, I'd like to have the location appear in Column C.

Ex:
A            B              C
17          5              B2
8           17             B3
5           8               B1


Thanks for any help!


Configuration: Windows XP / Internet Explorer 7.0

rizvisa1 · Accepted Answer

use match function

=IF(ISERROR(MATCH(A2, B:B, 0)), "", MATCH(A2, B:B, 0))

It will show the row number of B where there is a match

If you want to see cell address you can try
=IF(ISERROR(MATCH(A2, B:B, 0)), "", "B" & MATCH(A2, B:B, 0))

alaisa · Answer

Thanks!

Matching 2 columns in Excel

2 responses

Subscribe To Our Newsletter!