Windows XP Lookup Functions

[donvonbarnes]

I am trying to use lookup function in a cell to calculate the amount of foreign currency due a customer by multipling the country's exchange rate by the amount of US dollars being exchanged.

Does anyone have suggesions?

 

[psd99]

good luck mate on finding someone here to help you on this sort of thing

no luck for me so far

 

[Ian]

What do you mean by a lookup function? Something that will get the daily exchange rate and apply that to the formula automatically?