You don't need a lookup formula, just store the exchange rate somewhere, and
multiply by that rate.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"cuffie" wrote in message
...
how do you convert dollars to pounds using a lookup formula?