Information on sheet 1 is automatically updated from a database on a once daily schedule.
Cells on sheet 2 use a vlookup function that points to data on sheet 1. The formulas populate sheet 2 cells A2:Y2
If I mark sheet 2, cell A1 with ‘Yes’ or “z”, I want cells A2:Y2 to remain constant for as long as I have them marked ‘Yes’ or ‘z’, even when sheet 1 does its daily update and while cells A3:Y3 continue to change.

I tried a few IF functions but not having any luck