Hello,

I am trying to use a lookup function to calculate the following:

To determine the amount of foreign currency due a custorm
My Excel looks like this:

Columns A & B
Country traveling to: England
US Dollars to exchange: $1,000.00
Country's currency: Pound
Amount due customer:

Columns D, E, & F

Country Currency Exchange Rate
England Pound 0.6200
France Euro 0.9525
Germany Euro 0.9526
Canada Dollar 1.5603
How do I set up the calculation to calculate the foreign currency the
customer is due and that this figure appears in cell B8 labeled "Amount due
customer". The first one shoulw list $620, but my lookup function gives me
#N/A...please hlep