i have 2 worksheets in one excel file

------------------------------------------------------------------------------------------
sheet1:

Currency ---------------Amount

AUD --------------- 25,000,000
JPY --------------- 85,000,000
EUR --------------- 1,000,000

------------------------------------------------------------------------------------------

Sheet 2: (Currency Cross-Rate in USD)



USD--------------- $1.00
GBP--------------- $2.049194991
EUR--------------- $1.379994037
JPY--------------- $ 0.008185748
AUD ------------- $ 0.880441264

--------------------------------------------------------------------------------------

Question:
I need to generate a function which does the following:

IF a currency is "EUR" (in sheet1) , the next cell should multiply itself
with 1.379994037 (in sheet2).

So i have a list of currency and amounts in different currencies. THe
functions should automatically match the Currency and multiply it's value.

IDEA: if the currency is in JPY, then the Amount in JPY should be multiplied
with USD equavelent (which is $0.008185748).

All currencies should be in USD-equivelent.

DOn't worry, i have my own currency sheet !


Thank you so much !

---------