And to clarify my own mistake, I ONLY want the numbers to show up, I do not
want to see the words in the cell after selecting from the dropdown list

"SJAdams4444" wrote:

To my understanding, concatenate function combines two strings together??
I want to be able to select the words for the account names in the drop down
list, and then have the numbers corresponding to that Account Name show up,
but for some formatting reasons, I want this done in one same cell. Or if it
has to be more, I want only 1 cell to show, the others can be hidden, but I
want to be able to only interact with the one cell on the worksheet.

"Marcelo" wrote:

use an auxiliar cell with vlookup and concatenate funcions combined

--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"SJAdams4444" escreveu:

I want to be able to create a drop down list in ONE cell that shows names of
certain accounts, but when you select the name of the account, the number
corresponding to that account shows in the SAME cell. Is this at all
possible?