Hi!

What does your formula look like?

Try this:

=B3*IF(ISNUMBER(VLOOKUP(B2,D2:F5,3,0)),VLOOKUP
(B2,D2:F5,3,0),0)

Biff

-----Original Message-----
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


.