In Excel, to find lowest numeric values with multiple criteria based on the selection of the dropdown lists, I will use an Excel table, data validation to create dropdown lists and the SMALL IF formula.
I have the following dataset. Now I want to find lowest scores in G6 when the user makes a selection from the Group and Subject dropdowns in G2 and G3 respectively.
![Dataset Dataset](https://kunalexceltip.com/wp-content/uploads/2024/03/Dataset-15.png)
To accomplish the task, I perform the following steps:
I convert the source data into an Excel table and name it as data, like shown below:
![Converting the source data into an Excel table Converting the source data into an Excel table](https://kunalexceltip.com/wp-content/uploads/2024/03/Converting-the-source-data-into-an-Excel-table-4.gif)
By creating an Excel table, the formula will update automatically when new records are added or deleted in the source data.
I use data validation to create Group dropdown list in G2, listing unique groups in column B: A and B, by going to Data > Data Validation > Allow: List > Source: A,B
![Using data validation to create dropdown list Using data validation to create dropdown list](https://kunalexceltip.com/wp-content/uploads/2024/03/Using-data-validation-to-create-dropdown-list-2.png)
I use another data validation to create Subject dropdown list in G3, listing unique subjects in column C: English, Maths and Science, by going to Data > Data Validation > Allow: List > Source: English,Maths,Science
![Using data validation to create dropdown list Using data validation to create dropdown list](https://kunalexceltip.com/wp-content/uploads/2024/03/Using-data-validation-to-create-dropdown-list-3.png)
To find the bottom score, I construct my SMALL IF formula in G6, like shown below:
![Constructing SMALL IF formula Constructing SMALL IF formula](https://kunalexceltip.com/wp-content/uploads/2024/03/Constructing-SMALL-IF-formula.gif)
Your dropdown SMALL IF formula is ready! I hope this post helped you.