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!

Data Validation under Allow: select List Source: =select a list in
Column A OK

"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!

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!