Hello,
I'm sure there is a simple solution, so I hope I am clear in my explanation.
I have a workbook with a Data sheet that will have info pasted into it from another source every quarter or so. I want to create a table in a different sheet that matches two columns from the data sheet. If both columns match, then I want data from a separate column. I want to check two columns (first name & last name) to prevent incorrect information.
I have attached a small example.
Sheet 2, A12 & B12 will have data typed manually. I want to check sheet 1, column B for last name AND sheet 1 column C for last name. If they both match, enter Column E(Teacher) in Sheet 2 Column 3.
Forum Example.xlsx
Bookmarks