Forum Discussion
Solved
Generalized currency conversion
Dear community! I have a modified setup as figure below. I want to generalize my currency conversion to SEK from different currencies (not limited to the ones listed below). In other words, I wan...
QWeelon Almost correct. You need to make the references to the lookup array and the return array absolute, using $ signs.
Removed the table style in the attached workbook, so that you can see what I mean. Though, I'd recommend to learn about structured tables. The will make your Excel-life a lot easier.
Trevlig helg!
QWeelon Since you tagged your question with Office365, I assume your Excel version supports XLOOKUP. The attached workbook contains a mock-up based on your picture. See if it works for you and if you can implement it in your real life workbook.
By the way, you'll notice that I included one extra currency, the SEK, in the lookup table at the top with a rate of 1.00.
- Thank you for your reply!
Yes, i'm currently in Office365 but unfortunately I'm not able to get it to work - probably because of the table formulas, it is not something I'm familiar with at the moment.
I tried to augment the formula to the following without success:
=XLOOKUP(A11,B4:B7,C4:C7,"!",0)*B11
Do I need to create tables for it to work properly? If Yes, how do I do in a way that they are compatible? (Never really worked with tables unless I needed to sort something, which is very rarely).
Sorry for the inconvienience
/QQWeelon Almost correct. You need to make the references to the lookup array and the return array absolute, using $ signs.
Removed the table style in the attached workbook, so that you can see what I mean. Though, I'd recommend to learn about structured tables. The will make your Excel-life a lot easier.
Trevlig helg!
- Noterade precis din svenska! Haha! Trevlig helg och tusen tack!
