Drop Down List, select by letter?

[Geek Girl 007]

I have a drop down list that is very long, I want to be able to select any letter and go to it from here, can this be done?

TEST.xlsx
	A	B	C	D
1
2		Name of product	Total
3			0
4			0
5			0
6			0
7			0
8			0
9			0
10			0
11			0
12			0
13			0
14			0
15			0
16			0
17			0
18			0
19			0
20			0
21		TOTAL	0
22
Sheet2

Cell Formulas
Range	Formula
C3:C20	C3	=COUNTIF(B3,"*")
C21	C21	=SUM(C3:C20)

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
C3:C21	Cell Value	=0	text	NO

Cells with Data Validation
Cell	Allow	Criteria
B3:B20	List	=LIST!$A$2:$A$59

 

[Peter_SSs]

Not with standard Data Validation. However, a work-around can be set up. Have a look through this article: Show Excel Data Validation Drop Down Items in Combo Box

 

[Geek Girl 007]

Not with standard Data Validation. However, a work-around can be set up. Have a look through this article: Show Excel Data Validation Drop Down Items in Combo Box

As always, Thanks Peter,
This one doesn't work with merged cells and the bigger more complicated sheet I am creating has merged cells
I created the TEST sheet so I could post it here.

 

[Peter_SSs]

This one doesn't work with merged cells

Did you look right through the article? There is a section headed

Code Sample 2 -- Works for merged cells and non-merged cells

 

[Geek Girl 007]

Did you look right through the article? There is a section headed

Code Sample 2 -- Works for merged cells and non-merged cells

It was a bit beyond my level especially because there were so many drop down lists in the final sheet I am working on.
I ending up using this instead.

How to Search Data Validation Drop-down Lists in Excel - Excel Campus

Learn a fast and easy way to search any data validation list or in-cell drop-down list with a free tool.

www.excelcampus.com

Once again thank you for the advice and support

 

[Akuini]

@Geek Girl 007
Another option: try using "Search_deList_v2.1", it's a free Excel add-in, it works on Excel 2007 or later.

Its function is to speed up the search in the data validation list. In any cell that has data validation (with type List) pressing ALT+RIGHT will open a User Form with a combobox. You can type multiple keywords (separated by a space) in the combobox to search items on the list.

By using this add-in, you don't need to have the combobox in your workbook, so you can save your files as .xlsx. And it work on any open workbook.

The new version has some additional features, some of them:
Several ways to search, like using AND or OR or LIKE operator , with or without keyword order.
Sort the list by original order or ascending order.
Widen or shorten the combobox width at run time.
Insert multiple entries into the cell.

You can find it here:
search-delist

 

[Geek Girl 007]

@Geek Girl 007
Another option: try using "Search_deList_v2.1", it's a free Excel add-in, it works on Excel 2007 or later.

Its function is to speed up the search in the data validation list. In any cell that has data validation (with type List) pressing ALT+RIGHT will open a User Form with a combobox. You can type multiple keywords (separated by a space) in the combobox to search items on the list.

By using this add-in, you don't need to have the combobox in your workbook, so you can save your files as .xlsx. And it work on any open workbook.

The new version has some additional features, some of them:
Several ways to search, like using AND or OR or LIKE operator , with or without keyword order.
Sort the list by original order or ascending order.
Widen or shorten the combobox width at run time.
Insert multiple entries into the cell.

You can find it here:
search-delist

I really like this, Thanks

 

[Akuini]

I really like this, Thanks

You're welcome, glad to help & thanks for the feedback.