Automatic Data Entry for Given Values

[tara_922]

Hiya all,

I have 158 rooms in a list. Cells in the A column can be any one of those 158 but only occur once. However, there are different types of rooms, from Studios to 4 bedrooms. I want the cells in the C column to auto populate with the room type when the room number is selected.

To make the data validation list work for column A I inserted in Column M all of the 158 rooms. In column N next to each of the rooms is the room type.

So I want excel to take the room number and match it to column N then putting the value of column N into the C column. Here's an example of my sheet

Col.A...Col.B......Col.C
523...Cecilia......1bed
616B..Cecilia......Studio B
719...Cecilia......3bedPRES
303A..Cecilia.....Studio A
403A..Cecilia......Studio A
403B..Cecilia......Studio B
411...Cecilia......1bed
503B..Cecilia......Studio B
603B..Cecilia......Studio B
601...Heriberta...2bed
610...Heriberta...2bed
710...Heriberta...1bedPRES
317...Heriberta...2bed
702...Heriberta...4bedPRES
703A..Heriberta...Studio A
704...Heriberta...2bed

Any help would be greatly appreciated!

Thanks,
Tara

 

[jeffreybrown]

Take a look at Vlookup....

http://www.contextures.com/xlfunctions02.html

 

[tara_922]

Thanks so much! I'm so excited to learn something new...have been curious about VLOOKUP for a while now but it was a little intimidating to be honest. now I have an excuse to tackle it!

Thanks again!

Tara