Each week, I download an Excel sheet for work that needs to be sent to supervisors. However, I also have to manually add a few, additional columns each week (i.e. on top of what comes with the original downloaded sheet).

I am looking for a formula that will allow me to use a unique identifier (a value in one column from Sheet 1) to automatically paste these manually added values into the appropriate, matching column in Sheet 2.

Essentially, I want Excel to read values in one column of Sheet 1, find that corresponding value in Sheet 2 (if applicable) and, if there is a match, automatically bring in the cell values from a different column in Sheet 1 into Sheet 2.

1.png

2.png