I honestly don't even know what to use for a search on this solution.

I am trying to set up a simple spreadsheet with two columns one being a Room# and the other being a Room Name. Is there a way to set it up so that I can enter the room number and the name auto populates in the next column?

Thank you