I've looked at a lot of tutorials and haven't quote found the answer I'm looking to get. I have two sheets (see sample attached). Both sheets have the same names (column b) but also potentially different values (or matching). I'm looking to use Sheet 1 as the reference sheet and then look through sheet 2 and find all the values that match in Sheet 2 (might be more than one) and return that value along with the value of the column in the right. Ideally I could run it and see all the matches of the items in Column B, return the line items that match (column a) and show the values in Column C so I can see if they're different.
I added the sample and desired result to illustrate what I'm looking for.
I added the sample and desired result to illustrate what I'm looking for.