Dear all,

I need help with my drop list.
First of all i have sheet with all my data and i have define the name of each table.
I have about 15 categories table and a table with min 2 and max 100 items in each category.
I have made in a different sheet a drop list for my categories. Near this list i made another drop list with the items by using the formula =indirect() to arrange my itames by categories.
The problem that i have is:
- Some categories they have many items and is difficult to find some items. i need to put a formula to help me to put some letters and find what i need easily (easy searchable). If somebody like to help me i can send it to him to see it and help me. Is about a costing excel file.

Thanks!!!