Forum Discussion
Using calculation results as values
I'm using a calculated value as a conversion factor, but if circumstances change at random, I need to start using a fresh conversion factor. Although I can design the cell containing the factor to ch...
I'd create a small table with the history of the ISF value:
You can use this in a VLOOKUP (or XLOOKUP if you have Microsoft 365) formula to obtain the ISF that applies to a certain date.