Spreadsheet: 859137d1707596443-trying-to-reference-an-array-within-a-formula-to-output-corresponding-value-test-formula
Sheet: Reccomended Nutrition Values

 |  | Weight (Lbs) | Height (Ft) | Height (In)
ND means No Data |  | 175 | 5 | 8.8 |  | I want to add a Pregnant? And separate Lactating? Check box to also influence the values displayed below
Sex | Age | Weight (kg) | Height (m) | Activity Level (1-1.5) | Weight [NAME] (0.9-1.05) | Min - No Activity + Weight Goals | Recommended + Weight Goals | [NAME] | Male
Male | 30 |  |  | 1.15 | 0.98 |  |  |  | Female
Nutrition Values |  |  |  |  | The values of this chart should reflect the correct demographic inputed above.
Nutrient | Min | Recommended | [NAME] | Notes | Note that I've selected unique values for the energy of carbohydrates etc, it would be nice if the user could use a slider/input their own ratios and have those final values displayed correctly in the same chart.
Calories (kcal) |  |  |  | Total Energy calculated from Macros:
Total Carbohydrates (g) |  |  |  | Min 45% - 65% Max (Energy)
Total Protein (g) |  |  |  | Min 10% - 35% Max (Energy)
Total Fat (g) |  |  | ND | Min 20% - 40% Max (Energy)
Saturated Fat (g) |  | 10 | 20 | .75g protein/Lbs/Day
Trans Fat (g) |  |  | ND | % of kcal from [NAME]:
[NAME] (g) |  | 44 | ND | % of kcal from Protein:
Polyunsaturated Fat (g) |  | 22 | ND | % of kcal from Fat:
Omega-3 [NAME] (g) | 1.6 | 1.6 | ND | Min 0.6% - 1.2% Max (Energy)
Omega-6 [NAME] (g) | 14 | 17 | ND | Min 5% - 10% Max (Energy)
Dietary Fiber (g) |  | 28 | 50
Insoluble Fiber (g) |  |  | ND
Soluble Fiber (g) |  |  | ND
Total Sugars (g) | 0 | 0 | 100
Free Sugars (g) | 0 | 0 | 100
Added sugars (g) | 0 | 0 | 50
Cholesterol (mg) | 0 |  | 300 | Dietary cholesterol does not affect levels of arterial cholesterol.
LDL (mg) |  |  | ND
HDL (mg) |  |  | ND
Amino [NAME] |  |  |  | WHO Reccomended
H Histidine (mg) |  |  | ND | 10
I Isoleucine (mg) |  |  | ND | 20
L Leucine (mg) |  |  | ND | 39
K Lysine (mg) |  |  | ND | 30
M Methionine (mg) |  |  | ND | 10.4
C Cysteine (mg) |  |  | ND | 4.1
F Phenylalanine (mg) |  |  | ND | 12.5
Y Tyrosine (mg) |  |  | ND | 12.5
T Threonine (mg) |  |  | ND | 15
W Tryptophan (mg) |  |  | ND | 4
V [NAME] (mg) |  |  | ND | 26
Vitamins
A Vitamin Family (μg) | 625 | 900 | 3000 | Most people get too much [NAME]
Preformed [NAME] (μg) |  |  | 3000
[NAME] (μg) |  |  | 3000
Retinal/Retinaldehyde (μg) |  |  | ND
[NAME] (μg) |  |  | ND
[NAME] (μg) |  |  | ND
Caratanoids (μg) |  |  | 3000
beta-[NAME] (μg) |  |  | ND | beta-[NAME] can be converted as needed to Vitamin A in the body.
[NAME] (μg) |  |  | ND
beta[NAME] (μg) |  |  | ND
[NAME] (μg) |  |  | ND
Other (μg) |  |  | ND
[NAME] (μg) |  |  | ND
[NAME] (μg) |  |  | ND
Zeaxanthin (μg) |  |  | ND
B Vitamin Family
[NAME] (mg) | 1 | 1.2 | ND
B2 [NAME] (mg) | 1 | 1.3 | ND
B3 Niacin (mg) | 12 | 16 | 3000 | 35
Niacinamide (mg) |  |  | ND
Nicotinamide Riboside (mg) |  |  | ND
B5 Pantothenic Acid (mg) | 5 | 5 | ND
[NAME] (mg) | 1.1 | 1.3 | 100 | Pyridoxine - most important (only one to meet human requirements).
Pyridoxal (mg) |  |  | ND
Pyridoxamine (mg) |  |  | ND
[NAME] (μg) | 30 | 30 | ND
B9 Folate (μg) | 320 | 400 | 1667 | 1000
[NAME] (μg) | 2 | 2.4 | ND
C [NAME] (mg) | 75 | 90 | 2000
D Vitamin Family (μg) | 10 | 20 | 100
D1 Ergocalciferol 1:1 Lumisterol (μg) |  |  | ND
D2 Ergocalciferol (μg) |  |  | 100 | D2 Ergocalciferol - Most important.
[NAME] (μg) |  |  | 100 | [NAME] important.
D4 22-Dihydroergocalciferol (μg) |  |  | ND
D5 Sitocalciferol (μg) |  |  | ND
E Vitamin Family (mg) | 12 | 15 | 1000
E1 alpha-Tocopherol (mg) |  |  | ND | [NAME] is the only form that is recognized to meet human requirements.
E2 beta-Tocopherol (mg) |  |  | ND
E3 gamma-Tocopherol (mg) |  |  | ND
E4 delta-Tocopherol (mg) |  |  | ND
E5 alpha-Tocotrienol (mg) |  |  | ND
E6 beta-Tocotrienol (mg) |  |  | ND
E7 gamma-Tocotrienol (mg) |  |  | ND
E8 delta-Tocotrienol (mg) |  |  | ND
K Vitamin Family (μg) | 120 | 120 | ND
[NAME] (μg) |  |  | ND
[NAME] (μg) |  |  | ND
Minerals
Sodium (mg) | 1500 | 2300 | ND
Potassium (mg) | 3400 | 3400 | ND
Iron (mg) | 6 |  | 45 | 1.8 Times higher in vegetarians
Calcium (mg) | 800 | 1300 | 2500
Chloride (mg) | 2300 | 2300 | 3600
Choline (mg) | 550 | 550 | 3500
Chromium (μg) | 35 | 35 | ND
Copper (mg) | 0.7 | 0.9 | 10
Iodide (μg) | 95 | 150 | 1100
Magnesium (mg) | 330 | 420 | 770
Manganese (mg) | 2.3 | 2.3 | 11 | Manganese toxicity is very dangerous; can cause headaches, bone loss, circulation problems
Molybdenum (μg) | 34 | 45 | 2000
Phosphorous (mg) | 580 | 1250 | 4000
Selenium (μg) | 44 | 55 | 400
Sulfur (mg) | 960.8898 |  | ND | 13mg/kg
Zinc (mg) | 9.4 | 11 | 40
Trace Minerals
Arsnic (mg) | 0 | 0 | 0
[NAME] (mg) | 0 | 0 | 20
Fluoride (mg) | 4 | 4 | 10
Nickel (mg) | 0 | 0 | 1
Silicon (mg) | 0 | 0 | ND
Vandium (mg) | 0 | 0 | 1.8