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.
Column A = Department
Column B = Position code
Cell A2 =
Call B2 =
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 =
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