Quote:
Originally Posted by DukeNova
I work in a hotel and I'm working on a system to improve the fluidity between the front desk and housekeeping departments.
On one sheet I have a list of every room number and then the room type in the adjacent column. ie A1: 800, B1: NPK.
What I need now is when I'm on a separate sheet and I put in 800 in the Room column that it will auto populate "NPK" into the adjacent type column.
I've tried a few things already but nothing's worked yet. Any help would be appreciated.
|
VLOOKUP is what you need.
Have a look at the yellow cell on sheet 2 in the attached.
If you need explanation of how it works, just let me know.
S.