Dave Stone
asked on
Compare Columns Excel
Hello,
I have 2 columns, (A&B)of data that I would like to compare and find matches. If there are matches I would like the matched cells to populate column C. Is there a simple way to do this? I have attached a file with some of the data as an example.
Thank you
Book1.xlsx
I have 2 columns, (A&B)of data that I would like to compare and find matches. If there are matches I would like the matched cells to populate column C. Is there a simple way to do this? I have attached a file with some of the data as an example.
Thank you
Book1.xlsx
Away to do it might be using conditional formatting -> highlight cell rules -> dulpicates, and then filter the color out.
put this in column C =IFERROR(INDEX(A:A,MATCH(B 2,A:A,0)), "No Match")
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
It tells me there is an error
there is no error. please see formula embedded in attached file.
Book1.xlsx
Book1.xlsx