Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community
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