I'm assuming that your changing the rate quarterly.

Add a column to your lookup table for each quarter's FX rate so instead of
using a lookup range of A1:B5 you would use A1:E5 (Country, Q1 Rate, Q2
Rate...) (There are other ways, but it may be helpful to have the rates
laid out in a table so you can have that supporting documentation available
for other uses)

Then for the lookup use

=VLOOKUP("country",A1:E5,CEILING(MONTH("transactio ndate")/3,1)+1,FALSE)

If you're only updating the rates twice a year, then change the "/3" to "/6"
and obviously eliminate the unnecessary columns from the FX table.

HTH

PC



"Michael" wrote in message
news:agCle.364$xu3.202@lakeread02...
Hi Folks - Here's my situation. I have to convert local currencies into
dollars based on a conversion rate. The conversion rate changes a few
times
per year. So, my sheet looks like this:

Value in Local Currency Local Currency Value in Dollars

100,000 HK 75,000
200,000 DHS 175,000


For instance, say the rate for HK conversions is .55 effective 1/1/2005.
So,
I have many HK conversion transactions based on that rate. (I use a lookup
to determine what currency to convert and what rate to use). Now, on
7/1/2005, the rate changes to .65. If I change the rate in my lookup
table,
then all transactions from 1/1/2005 will change. I need way to preserve
the
rate conversions from 1/1/2005 through 6/30/2005. Any ideas?

Thanks.

Michael