Forum Discussion
Working on pulling from a range AND another value
I have 40 ranges (two cells each) with weights. - 20 for female weight ranges - 20 for male weight ranges Range Examples FEMALE1 is "109.9" (and below) FEMAL...
I'd create a lookup list. In this example it is on the same sheet, but you can place it on a different sheet as well.
You can then use the formula
=IF(H2="F","FEMALE"&MATCH(F2,$N$2:$N$22),IF(H2="M","MALE"&MATCH(F2,$O$2:$O$22),""))
HansVogelaar - Thank you for the pointer! I'll work on it over the weekend and will reply again with results. Much appreciated!