Index , Vlookup Average Formula

[Sparda142]

Hello,

I am trouble creating a formula to go into Cells B2:I2, Im trying to have Excel say Find the Text "Scheduled Date" match the date below with a date in Row 1 and provide the information in Column M for Test 1 , Only Information from the Text "Scheduled Date to Subtotal" Belongs to Test 1. I have tried using a few IFS formula with combination of Vlookup but have failed.
Please help me create a formula that will do the job Excel Gods and have mercy on me! ray:

Column A

Column B

Column C

Column D

Column E

Column F

Column G

Column H

Column I

Column J

Column K

Column L

Column M

1

Test G

3/24

3/25

3/25

3/26

3/27

3/28

3/29

3/30

Total Average

N/A

N/A

2

Test 1

Test 1

N/A

3

Test 2

Schedule Date

N/A

Total Ad

4

Test 3

3/26

N/A

93.47%

5

Test 4

3/28

N/A

100%

6

Test 5

3/29

N/A

91.07&

7

Test 6

Subtotal:

N/A

94.85%

8

Test 2

N/A

9

Schedule Date

N/A

Total Ad

10

3/24

N/A

21.41%

11

3/25

N/A

67.25%

12

Subtotal:

N/A

13

Test 3

N/A

14

3/29

N/A

41.44%

15

3/30

N/A

99.99%

<tbody>
</tbody>

 

[sheetspread]

Oh in that example you're skipping names, so:

Excel 2010
	A	B	C	D	E	F	G	H	I	J	K
1		24-Mar	25-Mar	26-Mar	27-Mar	28-Mar	29-Mar	30-Mar	empty Column	NAME & Dates	Percent
2	Jacob	100%	#N/A	#N/A	25%	#N/A	#N/A	#N/A		Jacob
3	Scott	80%	#N/A	#N/A	75%	#N/A	#N/A	80%		24-Mar	100%
4	Tim	#N/A	#N/A	#N/A	#N/A	#N/A	99%	#N/A		27-Mar	25%
5	Matt	#N/A	#N/A	#N/A	#N/A	63%	#N/A	#N/A		Jill
6	Howard	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!		25-Mar	30%
7										26-Mar	100%
8										27-Mar	99%
9										Scott
10										24-Mar	80%
11										27-Mar	75%
12										30-Mar	80%
13										Tim
14										29-Mar	99%
15										Matt
16										28-Mar	63%
17										Howard
Sheet7 (2)

Cell Formulas
Range	Formula
B2	=VLOOKUP(B$1,OFFSET(INDEX($J$2:$J$17,MATCH($A2,$J$2:$J$17,0)),,,MATCH("*",INDEX($J$2:$J$17,1+MATCH($A2,$J$2:$J$17,0)):$J$17,0),2),2,0)

 

[Sparda142]

Thank You so much everyone! You guys are awesome.