Finding Matches

[scargo]

I know this simple but I just cant find a way to get this to work properly.

I concatenated two set of data using a unique identifier and I was wondering how to be able to find the matches and pull them over into a separate list. Here is a sample of the data Column 1 being Temperature Service, Column 2 being "K" Line and Column 3 would be the matching data.

Please help!

 

[BenGee]

Hi

Are you wanting to look something up in 'Temperature Service' in Column 1 and look something else up in Column 2, and, where there are 2 matches, return Column 3? If so, what / where are the values in the sheet to look up?

Or, are you trying to do something else?