Hi everyone!
Looking for some help if possible.
I have cell G4 that needs to read data from one of two sheets, depending on the data that is entered for cell D4 (either male or female). The next two cells, E4 (age) and F4 (number of repititions performed) will be manually entered to get the outcome for G4. I just need to know how to put both of these formulas into G4 so that if I input “M” into cell D4, cell G4 will read from the male sheet and vice versa. Thank you in advance for your help!!!
The formulas that I need to put in G4 are:
=IF(D4=“M”(INDEX(MALE_PU!B2:AO117,0),MATCH(MALE_PU!A1:A145,0),MATCH(MALE_PU!B1:AO1,0)))
and the second formula is:
=IF(D4=“F”(INDEX(FEMALE_PU!B2:AO117,0),MATCH(FEMALE_PU!A1:A145,0),MATCH(FEMALE_PU!B1:AO1,0)))
Looking for some help if possible.
I have cell G4 that needs to read data from one of two sheets, depending on the data that is entered for cell D4 (either male or female). The next two cells, E4 (age) and F4 (number of repititions performed) will be manually entered to get the outcome for G4. I just need to know how to put both of these formulas into G4 so that if I input “M” into cell D4, cell G4 will read from the male sheet and vice versa. Thank you in advance for your help!!!
The formulas that I need to put in G4 are:
=IF(D4=“M”(INDEX(MALE_PU!B2:AO117,0),MATCH(MALE_PU!A1:A145,0),MATCH(MALE_PU!B1:AO1,0)))
and the second formula is:
=IF(D4=“F”(INDEX(FEMALE_PU!B2:AO117,0),MATCH(FEMALE_PU!A1:A145,0),MATCH(FEMALE_PU!B1:AO1,0)))