Hello. blood pressure based on various age groups

Blessing and peace to everyone.
I am very new to codes and formulas and hope to learn as much as possible here.
I work with disadvantaged people of all ages and been trying to find a way to document their blood Pressure based on their age in excel to e-mail to their Dr.'s. I already have a blood pressure program that calculates normal and hypertension ranges. Basically, there needs to be a drop down box that has the age ranges like (16-21) which I can do. Next I need a (IF?) formula that says, if the person is between 16-21, their normal blood pressure range should be, 124 78 for example. I know this is probably very simple; but after several days of trying to figure it out, I am at a loss. Thank in advance.

There a few ways you can do this. This easiest, create a lookup table >> C2:E5

Please Login or Register  to view this content.

B1 =LOOKUP(A1,$D$2:$E$5)

or you could imbed the lookup table directly into the formula

B1 =IF(A1<>"",LOOKUP(A1,{"16-21","22-27","28-33","34-39"},{"124/78","126/80","128/82","130/84"}),"")