Dynamic Array Searchable Dropdown

Hi.

I recently upgraded to Office 365 and am trying to take advantage of the new FILTER function to have a searchable drop-down list.

I am attaching a sample of how I am trying to use it. I was able to get it to work on the first row of the Measurement & Ingredient fields on the Recipe Entry sheet.

Is there a way to get this to work on all of the rows without having a separate spill list for each field?

My actual spreadsheet has room for 100 recipes. I would rather not have to create 2500 spill lists to make this work. Any suggestions?

TIA!

Originally Posted by Bo_Ry

Just 2 lists

Spill Lists
B4
=FILTER(Measurements,ISNUMBER(SEARCH(CELL("contents")&"",Measurements)),"Item Not Found")

C4
=SORT(FILTER('Main Ingredients List'!$C5:$C331,ISNUMBER(SEARCH(CELL("contents")&"",'Main Ingredients List'!$C5:$C331)),"Item Not Found"))

Thank you so much! I knew there was an easy way to do it.