Forum Discussion
Excel formula for adding correct exchange rate to correct cell
Hello, May I ask for help with this please. I am running a web store, and in columns A-C (marked as 1) you can see parts of the sales report (see screenshot). In column D, I wish to autom...
=IF(C2="USD",INDEX($L$2:$L$16,MATCH(B2,$J$2:$J$16,0)),INDEX($H$2:$H$16,MATCH(B2,$F$2:$F$16,0)))
You can use IF along with INDEX and MATCH.
An INDEX variant using the seldom used reference arrangement:
=LET(
i, XMATCH(dates, EUR[date]),
a, XMATCH(currency, {"EUR", "USD", "SEK"}),
INDEX((EUR, USD, SEK), i, 3, a)
)- Patrick2788 Thank you!
