Matching 2 columns in Excel [Solved/Closed]

Report
-
 alaisa -
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!


2 replies

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
760
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))
3
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2885 users have said thank you to us this month