On Sunday, September 9, 2012 4:12:06 PM UTC-7, DukeNova wrote:
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.









--

DukeNova

I may have read your request wrong. You might want something like this on the other sheet, where you enter the 800 in C1 and the formula returns from the Table Array on the first sheet. The 2 is the second column of that array and the 0 returns an exact match.

=VLOOKUP(C1,Sheet1!A1:B9,2,0)

Howard