Hi all, your help would be much appreciated below. I have many items sales from all differing regions in various currencies (and in no particular order), and would like to put them all into USD.
I would like to do a VLOOKUP into the "USD Summary" tab, and then depending on the currency in column B, multiply by the exchange rate in the "Currency Conversion" tab.
For instance, my VLOOKUP returns a value of $5, it is then picked up that Column B has the currency as AUD, it picks up the conversion rate of 0.69 and multiplies the $5.00 by this.
Feel free to ask any questions, thanks in advance!
Bookmarks