The easiest way to do this is to use list validation.

Basically, for this case, you'd Highlight Column B and go to Data
Validation. In the dropdown box choose "List" in the "Source" box put
in =$A:$A or just highlight all of column A.

That should get you what you're looking for.




Susie wrote:
I am trying to create a rooming list spreadsheet where I can pick roommates.
Is there a way to take the column of participants (say in Column A) and
create a dropdown in Column B with all the participant names. That way I can
choose a roommate from the list of registered participants. Please let me
know if this is possible.

Thank you!