Forum Discussion
Dependent calculations in tables
Hi all, I'm using a formula to calculate amounts into a master column in budget sheets depending on the currency. I'm pulling currency rates with the stock function into a separate sheet with named ...
If the master column has a label column next to it:
Name Value
Euro [EUvalue]
NOK [NOKvalue]
SEK [SEKvalue]
and then you can 'Format as a Table' and call that table something like "cTable" then the formula could be:
=XLOOKUP([@Cur], cTable[name], cTable[value]*[@Total], "")
having a table like that also makes it easier to maintain.
As for locking it you should be able to lock the sheet and use the options to allow insert rows and lock/unlock particular cells.