Forum Discussion
Generalized currency conversion
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!
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
/Q
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!
- To be honest, I have no idea why it don't work without the $, never thought it was something necessary unless you need to lock cell - I usually add them after getting the formulas to work. Anyway, it works like a charm! Great!
Thank you very much!
Maybe I'll watch a excel tutorial on structured tables on a rainy work days (I rarely use Excel in my work so this is just a 'hobby'). Do you have any videos to recommend?
However, for my current setup, it is important for things to be scalable, i.e I'm continuously adding rows every week and I want to do this without adjusting a table every time.
Anyhow, thank you again for your help! It is much appreciated!
Regards
/Q - Noterade precis din svenska! Haha! Trevlig helg och tusen tack!
QWeelon Var så god! Hela poängen med struktrerade tabeller är ju att du inte behöver ora dig när du lägger till några rader med valuta kurser. Allt uppdateras då automatisk utan att man måste skriva om alle formel som pekar till dessa valuta kurser. Men förstår vad du menar. Det ser inte så lätt ut om man inte är van med sådana tabeller.
