Drop Down list range based on two different cell values

Hi, I'm new to excel and was trying to make a workbook that will have a drop down list populate based on a user input in two separate cells. Basically, i have columns: name, pages, and books. I would like to have the drop down list match data by first finding the amount of books read, then finding the amount of pages read. Then any name that meets the criteria will be available in the drop down list. How can I do this? Thank you!

students.xlsx

Hi Jay

Welcome to the forum.

Please see the attached file that does what you need (I think!).

I achieved this by:
1) Creating an advanced filter on the Data page. This has a Criteria range and an Extract range. The Criteria are assembled by adding ">=" to the front of the value you enter in the Main sheet.
2) Using a change macro. When a cell value on the Main sheet changes, a macro fires. First it checks that it is in the correct range ("A2:B2") and if so, it carries out the filter set up by 1) above.
3) A dynamic named range (DNR) is used to retrieve the results and put them in the drop down list. The drop down list reference doesn't change, but a DNR allows the length of the list of values to be defined 'on the fly'.

Limitations.
If you intend to copy this down the page the code will need to be updated.
Similarly, if you move the data entry cells from A2:B2 or the source data you will need to adjust the macro.

Hope this helps.

Cheers, Rob.

Yeah, thanks rscsmith! This works perfectly!