How To Extract A Dynamic List With Variable Criteria In Excel

In the past I have done several tutorials on how to extract a dynamic list, two of which were based on multiple criteria. A link to those are below. But those supposed that you chose a option for each criteria. What if there are three criteria and you only choose one or two options? We will explore how to do that in this tutorial.

To download the file and follow along, go to:

Two previous tutorials on multiple criteria can be found here:

Do you need help with a formula or an Excel project?
Including a sample file is always helpful!

You can donate to my channel through any of the following:

PayPal:

Zelle or Venmo:

[utkarsharane]

You're a true genius! I hope you do great in life! Your formula really helped me a lot! Do good!

[wayneedmondson]

Nice one Mike! O365 makes it a little easier with FILTER, as in: with your same concept to trap for blanks with IF. Thanks for demonstrating this technique. Thumbs up!!

[kayslittlekitchen]

What if I just want this index list search to bring back a simple list without any of the extra aspects. I have a recipe list that I only want organized into proteins. What is the formula for one simple search to produce a list?