...
Copy old data into new spreadsheet.
- Keep only columns A-E (Q: Same for Staff and for Grads?)
- Paste into column "I" .(Q: Same for Staff and for Grads?)
Code for column "F". For Grads:
- =MATCH(E2,M:M,0)
For Staff:
- =MATCH(D2,L:L,0)
Code for column "H":
...
Fill in column "G" sequentially, 2 through to the end.
Insert rows ("down") in either data set (the one on the right, or the one on the left) to get them to match up again.