#### evanswright

##### Board Regular
Hello All,

I have the following data that I need to create a formula from:
HCC Raw Data TEST FILE.xls
3FEMALE0-34FEMALE35-44FEMALE45-54FEMALE55-59FEMALE60-64FEMALE65-69FEMALE70-74FEMALE75-79FEMALE80-84FEMALE85-89FEMALE90-94FEMALE95-GTMALE0-34MALE35-44MALE45-54MALE55-59MALE60-64MALE65-69MALE70-74MALE75-79MALE80-84MALE85-89MALE90-94MALE95-GTMED_F_D
4
5
60000001000000000000000000
HCC_Pt_C_Data

If the row has the number 1, I need to create a vlookup formula on the column heading that has the 1 in it. So for this example the 1 is in Female70-74. I need to then create a vlookup formula on Female70-74 to return the corresponding factor.
Thank you very much.

### Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

#### Jonmo1

##### MrExcel MVP
There will only be ONE occurance of the number 1 in that row?
Code:
``=VLOOKUP(INDEX(H1:AF1,MATCH(1,H6:AF6)),lookuprange,colref,false)``

#### evanswright

##### Board Regular
Yes only one for this example. Thank you.

Another question
I have another list that could have the number 1 populated 1 to 15 times in the range, would I be able use this formula?

Replies
5
Views
309
Replies
2
Views
393
Replies
3
Views
128
Replies
14
Views
223
Replies
1
Views
132

1,191,120
Messages
5,984,759
Members
439,909
Latest member
daigoku

### 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