SOLVED

# Excel Formula

Copper Contributor

# 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=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!

Thanks,

Will

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

# Re: Excel Formula

Simple XLOOKUP.

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

# Re: Excel Formula

Thankyou very much :)
1 best response

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

# Re: Excel Formula

Simple XLOOKUP.

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