I've done something similar using table formatting, conditional formatting, and filter. It won't return a single answer but will narrow down the table.
Pick the cell for your search term partial or otherwise. Select cells to search, conditional format with new formula,
=ISNUMBER(SEARCH(searchtermcell,celltosearch))
Conditional formatting has to be setup carefully. If C3:C1000 is your name list and C1 was your searchtermcell it would look like this when all cells to search are highlighted
=ISNUMBER(SEARCH($C$1,$C3))
After entering search term, filter table by color.
This are the formulas in my cell. Please advice what to do and in which formula?
=IF(ISNUMBER(SEARCH(CELL("contents"),F3)),MAX($E$1:E1)+1,0)
=IFERROR(VLOOKUP(ROWS($H$2:H2),LedgerMasters,2,0),"")
=OFFSET(H2,,,COUNTIF($H$2:$H$1472,"?*"))
All the names with 2 words in the table, of which the first word is common, only one name appears in the drop-down list.
Say I have 2 names in the list – 1. Reliance and 2. Reliance New,
If I type R both the names are visible in the search list below. If I type Reliance only one name is visible i.e., Reliance New and Reliance is not visible.
As the list is too long searching a name from a single alphabet will be tedious.