Forum Discussion

QWeelon's avatar
QWeelon
Brass Contributor
Sep 18, 2021

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...
Excel
Formulas and Functions
office 365
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Sep 18, 2021

    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!

Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor

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's avatar
QWeelon
Brass Contributor
Sep 18, 2021
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

Share

Resources