Multiple Parameter Lookup Function

%3CLINGO-SUB%20id%3D%22lingo-sub-2978004%22%20slang%3D%22en-US%22%3EMultiple%20Parameter%20Lookup%20Function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2978004%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20hoping%20someone%20here%20can%20help%20me%20out.%20I%20want%20to%20build%20look%20up%20function%20that%20will%20search%20multiple%20parameters%20and%20find%20the%20corresponding%20data%20in%20a%20table.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20included%20a%20screen%20shot%20of%20what%20the%20table%20looks%20like%20as%20it%20is%20too%20difficult%20to%20describe.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20to%20be%20able%20automatically%20use%20information%20in%20the%20excel%20doc%20where%20I%20record%20age%2C%20gender%2C%20pregnancy%20and%20lactation%20status%20to%20auto%20look%20up%20these%20values%20so%20I%20don't%20have%20this%20massive%20table%20to%20hunt%20through.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20secondary%20goal%20of%20building%20a%20table%20where%20I%20can%20input%20lab%20values%20for%20each%20micronutrient%20and%20it%20will%20then%20automatically%20provide%20information%20on%20which%20micronutrients%20are%20deficit%2C%20and%20which%20are%20excessive.%20From%20there%20it%20can%20recommend%20foods%20to%20increase%20consumption%20of%2C%20highlight%20potential%20side%20effects%20of%20deficiency%20and%2For%20toxicity%2C%20etc.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETIA!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2978004%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hello, 

 

I am hoping someone here can help me out. I want to build look up function that will search multiple parameters and find the corresponding data in a table.

 

I have included a screen shot of what the table looks like as it is too difficult to describe.

 

I want to be able automatically use information in the excel doc where I record age, gender, pregnancy and lactation status to auto look up these values so I don't have this massive table to hunt through.

 

I have secondary goal of building a table where I can input lab values for each micronutrient and it will then automatically provide information on which micronutrients are deficit, and which are excessive. From there it can recommend foods to increase consumption of, highlight potential side effects of deficiency and/or toxicity, etc.

 

TIA!

0 Replies