"Locking" an Index/Match formula
I am using an index/match column formula to look up an approver from another sheet. This is working fine, but I am going to need to change an approver and want to keep the previous approver listed for the past records.
Does anyone have any suggestions on how to do this?
I would rather not create a new column or copy old rows to a new sheet. I thought of adding a condition based on the date but then I think I would need multiple approver/date columns which could get out of hand.
Thanks in advance!
Help Article Resources
Check out the Formula Handbook template!