I am currently working on a rate exchange table. I know that I need a nesting an if statement with a vlookup, but am confused.

In cell D5 (on page 1-currency calculator), I have a list of countries to pick from. In cell e5, I would like to be able to type in a dollar amount, in column e6 I would like to calculate the current rate of exchange for the amount in e5.

Currency Value
Argentine Peso $5.00
U.S. $ = column 2, on curance rate page * $5.00

Page 1: Currency Calculator
Page 2: Currance Rate
column 1: country name
column 2: in US $$
column 3: Per US $$

So if I had $500 in US money, how much would I get if I went to Italy at the current rate of exchange.

I've been working on this for hours...Can anyone help.

Thanks

Houmoore4