Need to Match 2 pieces of data and return a third

[3furballs]

I have two spreadsheets both of which contain patient data each from a different system. I would like to match the value in Columns 1 & 2 (Date and Patient Name) on sheet 1 to the values in columns 1 & 2 on sheet 2 (I need both pieces to match because there are multiple patient entries for each date and each patient was seen on multiple dates) then return the value in column 6 on Sheet 2. Is there a way to get excel to do this? I've tried and it seems like all I can accomplish is excel telling me that most of the time the corresponding row doesn't match up from sheet 1 to sheet 2.

[Sam Capricci]

You can concatenate columns 1 & 2 on both sheets to give you distinct values, then do a vlookup on the distinct values to return other values.

[3furballs]

Thanks! not sure why I didn't think of that since I already had to do it with lastname and firstname.

[Sam Capricci]

Glad that helped and thanks for the rep points.

[arlu1201]

Based on your last post in this thread, its apparent that you are satisfied with the solution(s) you've received and have solved your question, but you haven't marked your thread as "SOLVED". I will do it for you this time.

In future, to mark your thread as Solved, you can do the following -
Select Thread Tools-> Mark thread as Solved.

Incase your issue is not solved, you can undo it as follows -
Select Thread Tools-> Mark thread as Unsolved.