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.
SergeiBaklan Thank you!
SergeiBaklan and OliverScheurich
If I wish to add a third currency, my domestic SEK, as shown in the screenshot columns N-P, how would I write the formula?
Thank you!
Okay, on any Excel that could be
=INDEX( INDEX($F$2:$Q$1000, 0, MATCH(C2, $F$2:$Q$2, 0)+1 ), MATCH(B2, INDEX($F$2:$Q$1000, 0, MATCH(C2, $F$2:$Q$2, 0)-1 ), 1 ) )- SergeiBaklan Thank you very much!
On which Excel platform/version you are? Is that Excel365, 2021 or earlier one?
