Home

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
YDanner
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
Without some sample data (preferably in Excel!) this is very difficult to answer.
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies