Forum Discussion

WillRiversxx's avatar
WillRiversxx
Copper Contributor
Feb 05, 2024
Solved

Excel Formula

Hi all! Firstly, dropbox link is here for this query! - https://www.dropbox.com/scl/fi/za56sfam3g1h4no6vzesr/Excel-Formula-Query-Dropbox.xlsx?rlkey=10ge3j2jjnpky2cjok5zojr1q&dl=0     I'm very...
excel
Formulas and Functions
training
  • Detlef_Lewin's avatar
    Detlef_Lewin
    Feb 05, 2024

    WillRiversxx 

     

    Simple XLOOKUP.

    =XLOOKUP([@Currency],Rates!$A$2:$A$25,Rates!$D$2:$D$25)*[@[Cost ]]

     

Detlef_Lewin's avatar
Detlef_Lewin
Silver Contributor
Feb 05, 2024

WillRiversxx 

 

Simple XLOOKUP.

=XLOOKUP([@Currency],Rates!$A$2:$A$25,Rates!$D$2:$D$25)*[@[Cost ]]

 

WillRiversxx's avatar
WillRiversxx
Copper Contributor
Feb 05, 2024
Thankyou very much 🙂

Resources