Hi,
I work in a hotel and we have 288 rooms. I made an excel sheet with in one column a list of the rooms (from 1 to 288) , a second column with the room type (for example Double, or Family, or Suite) and a third column with so next to each room number it shows whether the room is new or old.
Now I want to make a cell where if I input manually the room number (for example 101) to have another cell automatically show me the room type and another cell showing if the room is new or old!
Can someone assist?
Bookmarks