Return a value from a list based on multiple parameters

[Florian_Van_Lommel]

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 · Accepted 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. 

[#3]

Hi, this does the trick.
Thanks!