Vlookup result that then will not change?

Bit of an odd one - I'd love some expert help!

We have a spreadsheet ("Spreadsheet A") that uses VLookup to access another spreadsheet ("Spreadsheet B") to find the person in our company responsible for a geographic region.

Spreadsheet A then serves as a record of who handled certain matters.

When someone changes role or leaves our company, Spreadsheet B is updated to show the new person responsible for the relevant geographic region.

How can I stop Spreadsheet A from being updated with the new person's details?

Is there any sort of best practice in this sort of task?

Essentially I want Spreadsheet A to access Spreadsheet B for a name, and then "freeze" and no update any more if and when Spreadsheet B is updated.

A bit of a messy matter, and I'm not sure if I've explained it right, but here's hoping you guys can help.

Thanks a lot.

There are instructions at the top of the page explaining how to attach your sample workbook.

Are you still using Excel 2013 or something newer?

Add an date to the data and after that index/match

C13 =INDEX('Spreadsheet B'!$A$1:$C$6,MATCH('Spreadsheet A'!$A13,'Spreadsheet B'!$A$1:$A$6,0),MATCH('Spreadsheet A'!$B13,'Spreadsheet B'!$A$1:$C$1,1)) and drag down.

See the attached file.

How do you determine when the new name is available (what is the criteria for that?)

The old name is just overwritten with the new name when it happens! Very frustrating!

I am pushing for this method to be changed, but it is outside my control unfortunately.

Blocked replies simply mean that you have used something in the post that the forum thinks might be harmful. For instance, < and > need spaces either side of them or the forum will reject them, and anything like HTML code will be rejected. What were you trying to post?