Lookup formula-please help

[evanswright]

Hello All,

I have the following data that I need to create a formula from:

HCC Raw Data TEST FILE.xls
	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF
3	FEMALE0-34	FEMALE35-44	FEMALE45-54	FEMALE55-59	FEMALE60-64	FEMALE65-69	FEMALE70-74	FEMALE75-79	FEMALE80-84	FEMALE85-89	FEMALE90-94	FEMALE95-GT	MALE0-34	MALE35-44	MALE45-54	MALE55-59	MALE60-64	MALE65-69	MALE70-74	MALE75-79	MALE80-84	MALE85-89	MALE90-94	MALE95-GT	MED_F_D
4
5
6	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
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.
Please Help
Thank you very much.

 

[Jonmo1]

There will only be ONE occurance of the number 1 in that row?

=VLOOKUP(INDEX(H1:AF1,MATCH(1,H6:AF6)),lookuprange,colref,false)

 

[evanswright]

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?