S
Sonya
I have a sheet with prices for products and start and finish dates for those
prices:
Code Start Finish Price
6392 01/08/04 31/08/04 €24.56
6392 02/09/04 30/09/04 €30.00
I am using another sheet to work out costings, what formula can I use to
lookup the dates in the other sheet, eg 2*6392 bought on 18/09/04. I have
tried vlookup but that only finds the first instance of 6392 and doesn't
bring up the second date.
prices:
Code Start Finish Price
6392 01/08/04 31/08/04 €24.56
6392 02/09/04 30/09/04 €30.00
I am using another sheet to work out costings, what formula can I use to
lookup the dates in the other sheet, eg 2*6392 bought on 18/09/04. I have
tried vlookup but that only finds the first instance of 6392 and doesn't
bring up the second date.