just a VLOOKUP would do it


ig if G1 := 2-april05 then in H1: =VLOOKUP(G1,A1:C7,3,TRUE)

"darsg" wrote:

i have got 2 sheets of excel first sheet contains the date range and price
for that date range
eg.
A B C
01-Apr-05 30-Apr-05 26.00
01-May-05 31-May-05 24.00
01-Jun-05 30-Jun-05 32.00
01-Jul-05 31-Jul-05 46.00
01-Aug-05 31-Aug-05 60.00
01-Sep-05 30-Sep-05 43.00
01-Oct-05 30-Oct-05 26.00

what i want in sheet 2 is
A B
DATE PRICE
01-Apr 26
02-Apr 26
03-Apr 26
04-Apr 26
05-Apr 26
06-Apr 26
07-Apr 26
08-Apr 26
09-Apr 26
10-Apr 26
11-Apr 26
12-Apr 26
13-Apr 26
14-Apr 26