# Novice seeks advice - lookup?

#### Frank3923

##### Board Regular
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
ABCDEFGHIJK
1TOTAL FIRST DOWNSBy RushingBy PassingBy PenaltyTHIRD DOWN EFFICIENCYFOURTH DOWN EFFICIENCYNet Yards RushingTotal Offensive Plays (inc. times thrown passing)Total Rushing Plays
3TOTAL FIRST DOWNS11
4By Rushing2
5NET YARDS RUSHING23
6Total Rushing Plays18
Sheet2

### Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple

bump

#### Peter_SSs

##### MrExcel MVP, Moderator
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
ABCDEFGHIJK
1TOTAL FIRST DOWNSBy RushingBy PassingBy PenaltyTHIRD DOWN EFFICIENCYFOURTH DOWN EFFICIENCYNet Yards RushingTotal Offensive Plays (inc. times thrown passing)Total Rushing Plays
3TOTAL FIRST DOWNS1111
4By Rushing22
5NET YARDS RUSHING2323
6Total Rushing Plays1818
Fantasy Football

Replies
6
Views
596
Replies
1
Views
390
Replies
3
Views
3K
Replies
1
Views
386

1,191,581
Messages
5,987,456
Members
440,097
Latest member
Wint

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back