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
765
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 2942 users have said thank you to us this month

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!