Excel formula to select item from drop down list

%3CLINGO-SUB%20id%3D%22lingo-sub-319330%22%20slang%3D%22en-US%22%3EExcel%20formula%20to%20select%20item%20from%20drop%20down%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-319330%22%20slang%3D%22en-US%22%3E%3CP%3EDear%20Excel%20Experts%2C%3C%2FP%3E%3CP%3EI%20have%20one%20sheet%20with%20four%20drop%20down%20lists%20with%20each%20a%20variety%20of%20input%20parameters.%20In%20total%2C%20there%20are%2096%20possible%20combinations%20of%20the%20parameters%20involved%20in%26nbsp%3Ba%20calculation.%20Each%20combination%20array%20has%20a%20different%20value%20it%20returns%20after%20the%20parameters%20were%20selected.%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20a%20second%20sheet%2C%20I%20have%20a%20full%20list%20of%20all%20possible%2096%20combination%20arrays.%20My%20idea%20is%20now%2C%20that%20I%20want%20to%20include%20a%20formula%20in%20a%20cell%20behind%20each%20combination%20that%20finds%20and%20then%20selects%20the%20respective%20parameters%20from%20the%20drop%20down%20lists%20in%20the%20first%20sheet%20and%20then%20copies%20the%20output%26nbsp%3Bvalue%20from%20sheet%20one.%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20realization%20is%20that%20the%20only%20solution%20contains%20a%20macro%20with%20an%20iterative%20code.%20Any%20ideas%20or%20assumptions%3F%20Thank%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-319330%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%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-320002%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20formula%20to%20select%20item%20from%20drop%20down%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-320002%22%20slang%3D%22en-US%22%3EWithout%20some%20sample%20data%20(preferably%20in%20Excel!)%20this%20is%20very%20difficult%20to%20answer.%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Dear Excel Experts,

I have one sheet with four drop down lists with each a variety of input parameters. In total, there are 96 possible combinations of the parameters involved in a calculation. Each combination array has a different value it returns after the parameters were selected. 

In a second sheet, I have a full list of all possible 96 combination arrays. My idea is now, that I want to include a formula in a cell behind each combination that finds and then selects the respective parameters from the drop down lists in the first sheet and then copies the output value from sheet one. 

My realization is that the only solution contains a macro with an iterative code. Any ideas or assumptions? Thank you!

1 Reply
Highlighted
Without some sample data (preferably in Excel!) this is very difficult to answer.