Need to replace values in only certain rows of a column based on separate column values

I did about 40 find and replaces (FRs) but did not change the output on one of them. 6 hours later i discovered my mistake. My data is on names and their job roles, my FRs narrowed the job roles down into President, Vice President, Director, and Other. Unfortunately, I accidentally turned Vice President into Other. Now actual "Others" are mixed with the vice presidents who are now labelled as others.

I still have the raw data with the names and roles, if I get all the Vice Presidents labelled correctly on the raw sheet, is there anyway for me to only replace only roles on a separate sheet based on the names that are in the same row as the Vice President label?

Welcome to the forum.

If I get it right, try this in E2 and copy down:
=INDEX($B$2:$B$8,MATCH(D2,$A$2:$A$8,0))

Good luck!