INDEX Help Again!

[Frick]

In Sheet1 I have Col's with Dates:

C1:R1 each col is start of year 1/1/04, 1/1/05 etc
C2:R2 each col is End of Month with formula EOMONTH, returning 12/31/04,
12/31/05 etc.
C46:R46 each col contains Data

In Sheet 2 I have Col's with Dates:

D3:O3 each col is start of year 1/1/06, 1/1/07 etc
D4:O4 each col is End of Month with formula EOMONTH, returning 12/31/06,
12/31/07 etc.

I need a formula for range D15:O15 that will;

match the date ranges in Sheet2 with the dates in Sheet1 and bring
forward the Data to Row 15

Thanks for all the help

 

[Ragdyer]

You can try this array formula.
Enter this in D15 of Sheet2, using CSE (<Ctrl> <Shift> <Enter>), which will
*automatically* enclose the formula in curly brackets ({}), if done
correctly:

=INDEX(Sheet1!$C$46:$R$46,MATCH(TEXT(D3,"m,d,y"),TEXT(Sheet1!$C$1:$R$1,"m,d,
y"),0))

You can then drag right to copy, out to column O.