Searchable Drop Down on Different Sheet

Hi FDibbins,

All I'm trying to do is create a "searchable" drop-down list in the cells (A14:A94) on JAN Budget sheet, using the Income-Payer list on LIST sheet as source.

I also need a "searchable" drop-down list in all cells (H14:H94) on JAN Budget sheet, using the Expense Payee list on LIST sheet as source.

Finally, I need a "searchable" drop-down list in all cells (O14:O94) on JAN Budget sheet, using the Misc-Expense list on LIST sheet as source.

What I mean by "searchable" is that you enter just a few characters into the input field (for example: "sp"), then click the drop-down arrow, and only items from the list containing "sp" are presented as selections. For example, if spouse, spending and special (alone with other entries) are all in the list, only those 3 will be presented as selections. The "sp" is the criteria entered and used in the initial search.

I know how to do simple data validation, by naming the individual list, then using that name as source. But that drop down list will display all entries and you must scroll the entire list the get what your want. Whereas with the 'searchable" drop down, you first enter the criteria or whatever letters you know are in what you are looking for, and only those items are presented as selections.

I've attached a fresh and new workbook "Budget Worksheet2"

I hope I'm being clear about what I'm trying to do. Sorry for any confusion.