SOLVED

Excel Formula

Copper Contributor

Hi all!

Firstly, dropbox link is here for this query! - https://www.dropbox.com/scl/fi/za56sfam3g1h4no6vzesr/Excel-Formula-Query-Dropbox.xlsx?rlkey=10ge3j2j...

 

 

I'm very unsure what formula to place on this spreadsheet of mine, we're using this to track the spend on travel and subsequently there are different exchange rates displayed. I'm trying to find a formula to use which will read what was manually input by whoever fills this sheet in (If they select GBP/EUR etc) and then convert to Local currency (In this case, GBP) - I have provided a table of rates, but just don't know what the best 'One formula fits all' is! 

 

Your help is much appreciated! 

 

Thanks,

 

Will  

2 Replies
best response confirmed by WillRiversxx (Copper Contributor)
Solution

@WillRiversxx 

 

Simple XLOOKUP.

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

 

Thankyou very much :)
1 best response

Accepted Solutions
best response confirmed by WillRiversxx (Copper Contributor)
Solution

@WillRiversxx 

 

Simple XLOOKUP.

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

 

View solution in original post