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 ...
Thank you both! Just tried out Peter's solution and it works really well. Just recently learned about the SWITCH function and this is a good, practical way of using it.
The XLOOKUP solution also makes sense, I'll experiment a bit with it. Makes it easy to add in new currencies if needed, for example. As for locking, I tried it out now and it does work, except that I couldn't add more rows to a table, which won't work for my application.