adminragnar
Sep 14, 2024Copper Contributor
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...
- Sep 14, 2024
=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.