| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Auto populate from list on separate sheet
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Populate excel sheet based on values in a separate sheet | Excel Discussion (Misc queries) | |||
| auto populate a list | Excel Discussion (Misc queries) | |||
| Need to auto-populate a list. | Excel Discussion (Misc queries) | |||
| Auto populate from list/source | Excel Worksheet Functions | |||
| Auto populate from list/source | Excel Worksheet Functions | |||
Threaded Mode
