Ok, I've uploaded an example, there is usually a lot more data in this sheet but have deleted everything other than what's part of my query (It was easier than making it all up) and obviously made up rubbish customers.
So, under the customer header, there is usually around 300 or so customers and they choose this using the drop down arrow, set up using data validation. Once the customer is selected it brings over the industry code automatically using vlookup. I need to know if there is an easier way for me to set up the customer selection process as scrolling though a list of that many customers using a drop down box can be painful. Ideally like I said it would be good if there was some form of search box or something that I could use so they only need to type the first few letters of a customer name to either bring in a suggested customer or bring them down the list to the customers starting with those letters. As far as I know it's now possible but it would be great if someone has an answer!
