Thank you for your reply, however I have to use a lookup formula.

"Bob Phillips" wrote:

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?