Multiply A VLOOKUP By Exchange Rate (with different rates!)

[mitchfrommelbourne]

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!

[mehmetcik]

First tidy up column A on the currency conversion tab so that it is only three letters

Then:
Formula for E2 =D2*INDEX('Currency Conversion'!B:B,MATCH(B2,'Currency Conversion'!A:A,0),1)

[mitchfrommelbourne]

Thanks so much, can I ask, and sorry I'm really not familiar with the Index function, how would you add the VLOOKUP so I can put all results into the USD Summary tab?

[mitchfrommelbourne]

All good I worked it out! Thanks so much mehmetcik.