Jan 18 2023 12:59 PM - edited Jan 18 2023 01:01 PM
I would use a function like XLOOKUP() or VLOOKUP() in EXCEL 2016. If you don't want to have functions in these cells later, you can make fixed entries in the cells from the formulas with COPY and PASTE-VALUES.
Would that be a working solution?