May 05 2021 12:07 AM
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,
May 05 2021 12:15 AM
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.
May 05 2021 12:18 AM
May 05 2021 12:15 AM
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.