Hi All,

I am wondering if it is possible in any way to create a searchable list in excel?

We have a 'job costing sheet' that staff fill in and send to me for invoicing which has a data validation cell at the top connected to a 'list' of customers. The staff find it painful going through a very large list to find the customer they need and would like to instead be able to click in the cell, start typing 'Ap..' for example and customer 'Apple' automatically appears. Or even if they type 'G' and it automatically brings them to the list of customers starting with G.

Any ideas on how I can get around this? The result of this list is also connected to a Vlookup in the cell next to it to bring across the correct accounting code.

Thanks!