Brent R Janetzki
New Member
- Joined
- Mar 11, 2017
- Messages
- 18
Hi Folks,I need a formula for the following.
Cell B127: Persons Gender (Male Female)
Cell B128: Age (Persons age
Cell: I192: Returns the average grip strength of the person
I am doing a grip strength assessment where by cell I192 returns the average grip strength over three attempts of the participant. I then want my formula to tell me where they sit in comparasion to the average for their age and gender which is recorded in another table that I will access via a vlooup table within the formula.
I need to write a formula that states if cell B127 is "Female" then take the age recorded in Cell B128, then go to the result in I192 and then go to my Vlookup table to return the value for the persons age, gender etc. I know how to do the vlookup part but just can't get the first part.
Thanks in advance
Cell B127: Persons Gender (Male Female)
Cell B128: Age (Persons age
Cell: I192: Returns the average grip strength of the person
I am doing a grip strength assessment where by cell I192 returns the average grip strength over three attempts of the participant. I then want my formula to tell me where they sit in comparasion to the average for their age and gender which is recorded in another table that I will access via a vlooup table within the formula.
I need to write a formula that states if cell B127 is "Female" then take the age recorded in Cell B128, then go to the result in I192 and then go to my Vlookup table to return the value for the persons age, gender etc. I know how to do the vlookup part but just can't get the first part.
Thanks in advance