Steve Bradshaw
New Member
Hi,
I am trying to create a spreadsheet whereby one column's fields will all be a drop down menu. This is easy using data validation but I am struggling to make my drop down lists searchable. (I can make the first one searchable using formulas I found on You Tube but this only works on the top cell. Is there an easy solution to this please?)
I have attached a sample whereby you will see the top cell in column B is searchable in as much when you type characters appearing in the list it will reduce the list (in column AB) to those containing the typed characters making the name search easier
kind regards
Steve Bradshaw
I am trying to create a spreadsheet whereby one column's fields will all be a drop down menu. This is easy using data validation but I am struggling to make my drop down lists searchable. (I can make the first one searchable using formulas I found on You Tube but this only works on the top cell. Is there an easy solution to this please?)
I have attached a sample whereby you will see the top cell in column B is searchable in as much when you type characters appearing in the list it will reduce the list (in column AB) to those containing the typed characters making the name search easier
kind regards
Steve Bradshaw