INDEX Help Again!

  • Thread starter Thread starter Frick
  • Start date Start date
F

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
 
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.
 
Back
Top