I have 2 spreadsheets with department names and position codes. The master spreadsheet lists all the department names and position numbers, while the other only has position codes.
I need for the second spreadsheet to look at the position code and match it with the position code on the master spreadsheet, then copy the information from the cell to the left of the position code on the master spreadsheet, into the cell to the left of the position code in the other spreadsheet.
For Example:
Master Spreadsheet:
Column A
= Department
Column B
= Position code
Cell A2
= 70600: PACU
Call B2
= 2145
Second Spreadsheet:
Column E
= Department
Column F
= Position code
Cell E2
= (Blank) ← this is the information that needs to be filled from the master spreadsheet
Cell F2
= 2145
Column E of the second spreadsheet needs to be filled with the information from column A of the Master spreadsheet, based on the Position code listed in column F of the second spreadsheet matching the position code in column B of the master spreadsheet