Forum Discussion
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 it eliminates names or numbers out of the sequence. Once you have found the name or number you are looking for I would like excel to populate that cell with the number that corresponds to the name or number that was typed in. Is that possible to do in excel?
For example: A2 ... start to type in the box John Smith and then a list pops up with all the John Smiths you have and their corresponding numbers
John Smith - 33345
John Smith - 33346
John Smith - 89476
And you choose John Smith - 33346
And now the cell has
33346 as the value
Please let me know if this is even possible. I don't have a .xlsx to post because I don't know how to create one of this type.
I appreciate your time and thank you in advance.
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, " - "), "")
