Novice seeks advice - lookup?

[Frank3923]

I am tracking some game stats for fantasy football. all my data items are across the top row. The web query data is in the left 2 columns, the row of the data items for the game, can vary, example "NET Rushing Yards" is the seventh column, on the game data, and it is the third data item. Looking for suggestions, on how I may find solution for this problem.

2007-Preson-Notes.xls
	A	B	C	D	E	F	G	H	I	J	K
1			TOTAL FIRST DOWNS	By Rushing	By Passing	By Penalty	THIRD DOWN EFFICIENCY	FOURTH DOWN EFFICIENCY	Net Yards Rushing	Total Offensive Plays (inc. times thrown passing)	Total Rushing Plays
2	Philadelphia Eagles (0-1-0)
3	TOTAL FIRST DOWNS	11
4	By Rushing	2
5	NET YARDS RUSHING	23
6	Total Rushing Plays	18
Sheet2

 

[Frank3923]

bump

 

[Peter_SSs]

I am tracking some game stats for fantasy football. all my data items are across the top row. The web query data is in the left 2 columns, the row of the data items for the game, can vary, example "NET Rushing Yards" is the seventh column, on the game data, and it is the third data item. Looking for suggestions, on how I may find solution for this problem.

I am not sure that you have told us exactly what the "problem" is that you want solved. So, taking a guess, is this it?

Formula in C3 copied across and down.

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K
1			TOTAL FIRST DOWNS	By Rushing	By Passing	By Penalty	THIRD DOWN EFFICIENCY	FOURTH DOWN EFFICIENCY	Net Yards Rushing	Total Offensive Plays (inc. times thrown passing)	Total Rushing Plays
2	Philadelphia Eagles (0-1-0)
3	TOTAL FIRST DOWNS	11	11
4	By Rushing	2		2
5	NET YARDS RUSHING	23							23
6	Total Rushing Plays	18									18
Fantasy Football