I’m using vlookup to autofill columns in a spreadsheet. Boss is using Excel to store records of data entry errors. Each operator has an op#, opid, manager, and name. I just enter the op# and have all other 3 columns autofill based on vlookup formulas.

Only problem is that sometimes an operator leaves, and the op# is recycled a few months later. When I update the vlookup table, the spreadsheet will retroactively assign all old errors under that op# to the new employee. The problem would be solved by just autofilling with the results of the formula, but not the formula itself. That way I can change the info in the vlookup table without the database part the spreadsheet changing.

Surely there is some simple way to do this I’m just not able to find online.