How to Add Dropdown in Search Cell or Autocompletes Remaining Letters

**hameezkhan85** · 07-20-2023, 04:00 AM

Hello,

I want it when I start typing in the "Item Search" It autocompletes the remaining letters from the "Sheet-2 Table" or shows a dropdown.

Hope You Understand...

THANKS.

**protonLeah** · 07-27-2023, 03:16 PM

Create named range:
ItemList =OFFSET(Sheet2!$B$1,1,0,COUNTA(Sheet2!$B:$B)-1)

insert Forms control ComboBox on cell F3
properties:

listfill range: itemlist

linked cell: F3

How to Add Dropdown in Search Cell or Autocompletes Remaining Letters

LinkBack

Thread Tools

Rate This Thread

Display

How to Add Dropdown in Search Cell or Autocompletes Remaining Letters

Re: How to Add Dropdown in Search Cell or Autocompletes Remaining Letters

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Dropdown list - formule to get only upper and lower case letters?

[SOLVED] Need Help with Formula to Search Starting set of Numbers and Enter Remaining 7 digits

[SOLVED] Help required - User input for text search and delete remaining rows

[SOLVED] List of keywords to search from another sheet cell contains many other letters

[SOLVED] Search CELL-A for one or two letters and display the found letters in CELL-B

How to search for multiple letters, & copy when certain letters are found.

Can I search within a dropdown cell?

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions