# Index Formula

#### davidhall80

##### Well-known Member
I have a list of employee names in column A beginning at row 10.
Beginning in column D row 2, I have weeks 1 through 52 ending 52 columns later, but still in row 2. In these 52 columns, I have sales data underneath which matches with the employees in column A. I need to know the first week my employee made a sale. If an empoyee made a sale, it will show up under the corresponding week, if he didn't, it will be a zero. In column B next to thier name, I need to know what week was there first week of sales. What is there first week without a zero.

example

A................B........C..........D............E.........F.........G...........H........I.....

....................................Week1...Week2..Week3..Week4..Weeks..Week6

John..................................0...........0.......0..........\$62...........0..........0

Sammy.............................0........\$25.......0...........0..........82...........0

David................................0..........0.......0............0.........0............\$37

John would be week4, sammy would be week 2 etc.....

### Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

#### fairwinds

##### MrExcel MVP
Hi,

Try:

=INDEX(\$D\$2:\$BC\$2,MATCH(TRUE,D10:BC10>0,0))

confirmed with Ctrl + shift + enter.

Thanks a million

Replies
3
Views
136
Replies
1
Views
130
Replies
9
Views
227
Replies
1
Views
349
Replies
0
Views
523

1,172,017
Messages
5,878,757
Members
433,370
Latest member
mcleven

### 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.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

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

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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