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

Check out the HLOOKUP function

"Arup C" wrote:

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