evanswright
Board Regular
- Joined
- Mar 22, 2007
- Messages
- 94
Hello All,
I have the following data that I need to create a formula from:
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.
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.