Hi everybody,
I have two sheets namely price_sheet and order_sheet, I have a price
database made with dynamic range which has the following headings on
"price_sheet"
   A             B               C                D
1. product    01/03/08    02/03/08     03/03/08 .............
2. Milk            10.00           12.00          14.00 .............
3. Sugar         16.00           18.00          20.00 .............

The prices are on the respective dates
Now I want to find out the content of the last cell address (in this case it
would be content of d1) I want to compare it with the order_date column on
"order_sheet" so that the price in the order detail don't change with the new
prices.
The order_sheet have the following columns
   A              B                    C                    D              E
1. Date         Order_no         Party_name     Product     Price
2. 01/03/08    1                   xyz                  Milk          10
3. 02/03/08    2                   zxy                  Milk          12