Trying to reference an array within a formula to output corresponding value

Hi,

Test Formula.xlsx

I am trying to make a Nutritional Value Chart that accurately displays all macro and micro nutrient data - appropriate to the demographic you input at the top.

I want the formulas within the min, recommended, and max columns to auto update with the correct information; according to the demographic information input above. That is to say, a child needs a different amount of protein and sodium, or a pregnant woman needs a different amounts of calories etc.

I can find all this information, and have the macros, vitamins, and mineral values on a separate sheet within the document. The only thing I don't know how to do is create a formula that references the array and correctly selects the appropriate value based on ***, and age.

A secondary question is, how can I make the charts on Nutrition Data sheet into tables with headings that span multiple columns?

The questions are posed within the document encase this wasn't clear.

Thank you!