I had no idea what to Google for this. Basically I have 2 Excel files: File A and File B.
Here is File A:
And here is File B:
I am trying to loop through File B. I want to look at each row's first and last name columns with the first and last name columns in File A. If I find a first and last name row in File B that matches the first and last name row in File A, then I want to update File A's row for the Med_Prof value.
For example, in File B, we see that the 2nd row where last name is "Sub" and first name is "Stan" matches the 3rd row in File A where last name is "Sub" and first name is "Stan." As a result, I will update the Med_Prof number in File A with the value 11.
I am unsure how to do this aside from manually copy / pasting values. However, for spreadsheets with thousands of values, this is not feasible.