SOLVED

Return a value from a list based on multiple parameters

%3CLINGO-SUB%20id%3D%22lingo-sub-2324976%22%20slang%3D%22en-US%22%3EReturn%20a%20value%20from%20a%20list%20based%20on%20multiple%20parameters%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2324976%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20order%20to%20have%20an%20efficient%20template%20for%20qualifying%20a%20certain%20parameter%20on%20a%20beverage%20packaging%20type%2C%20the%20correct%20specification%20needs%20to%20be%20applied.%3C%2FP%3E%3CP%3EThe%20specification%20is%20based%20on%20a%20combination%20of%202%20parameters%20which%20is%20filled%20in%20from%20a%20list%20in%202%20separate%20cells%3C%2FP%3E%3CP%3E(in%20attached%20example%20cell%20C14%20and%20C15).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20question%20is%20how%20to%20return%20the%20specification%20value%20based%20on%20the%20correct%20combination%20into%20a%20cell%20(in%20my%20example%20C17).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDevice%20%26amp%3B%20OS%3A%26nbsp%3B%3CSPAN%3EPC%2FWindows%2010%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EExcel%20product%20name%20and%20version%20number%3A%3C%2FP%3E%3CP%3EMicrosoft%20365%20Apps%20for%20Enterprise%3C%2FP%3E%3CP%3EExcel%20version%202008%20Build%2013127.20638%20Click-to-Run%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20any%20help%20provided.%3C%2FP%3E%3CP%3EWith%20kind%20regards%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2324976%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2325009%22%20slang%3D%22en-US%22%3ERe%3A%20Return%20a%20value%20from%20a%20list%20based%20on%20multiple%20parameters%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2325009%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1045411%22%20target%3D%22_blank%22%3E%40Florian_Van_Lommel%3C%2FA%3E%26nbsp%3BSince%20you%20mention%20that%20you%20have%20MS365%20apps%2C%20try%20this%20one%20in%20C17%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DFILTER(D3%3AD11%2C(B3%3AB11%3DC14)*(C3%3AC11%3DC15))%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3EIf%20you%20have%20Dutch%20Excel%2C%20you%20probably%20need%20to%20replace%20the%20commas%20by%20semi-colons.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2325010%22%20slang%3D%22en-US%22%3ERe%3A%20Return%20a%20value%20from%20a%20list%20based%20on%20multiple%20parameters%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2325010%22%20slang%3D%22en-US%22%3EHi%2C%20this%20does%20the%20trick.%3CBR%20%2F%3EThanks!%3C%2FLINGO-BODY%3E
New Contributor

Hi,

 

In order to have an efficient template for qualifying a certain parameter on a beverage packaging type, the correct specification needs to be applied.

The specification is based on a combination of 2 parameters which is filled in from a list in 2 separate cells

(in attached example cell C14 and C15).

 

My question is how to return the specification value based on the correct combination into a cell (in my example C17).

 

Device & OS: PC/Windows 10

Excel product name and version number:

Microsoft 365 Apps for Enterprise

Excel version 2008 Build 13127.20638 Click-to-Run

 

Thanks for any help provided.

With kind regards,

 

 

 

2 Replies
best response confirmed by Florian_Van_Lommel (New Contributor)
Solution

@Florian_Van_Lommel Since you mention that you have MS365 apps, try this one in C17

=FILTER(D3:D11,(B3:B11=C14)*(C3:C11=C15))

If you have Dutch Excel, you probably need to replace the commas by semi-colons. 

 

Hi, this does the trick.
Thanks!