Forum Discussion
johnsboxftm
Dec 05, 2023Brass Contributor
Type name in a cell and have it pull up list of names with #s and populate with the #
Hello, I would like to have cells in a certain column be able to be clicked on and when you do a little box appears or just type directly into the cell either a name or a number but as you type i...
HansVogelaar
Dec 05, 2023MVP
That'd be complicated, but you might do the following:
I assume that you have a list with the names in the form you show ("James Smith - 33345").
Select cell A2.
On the Data tab of the ribbon, click Data Validation.
Select List from the Allow drop-down, then click in the Source box and point to the range with the names.
Click OK.
A2 will now have a drop-down arrow.
In B2, enter the formula
=IFERROR(--TEXTAFTER(A2, " - "), "")