I want to enter information (e.g. RM1) and the second column would
automatically input information that would be equivalent to it (e.g. Room 1).

Example:
Column 1: RM1
Column 2: Room 1

However; I want it to change as the information changes.