Working with Drop Down List

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've looked around in the FAQ and other help areas - maybe I'm asking the
question wrong. (Not uncommon)

I have seen this done in the past - but I can't remember how it was created...

I have a list of room numbers - in a separate column I have a list of room
names. I recall that there was a way to create the list so that if someone
chose the room number from the list - the associated room name would appear
adjacent to it...

Was I dreaming? Is this possible? Or is this an INDEX (array) sort of thing?

Any help would be greatly appreciated.
 
VLOOKUP?

If Room Numbers and Names are (for example) in Columns A & B of Sheet2 (rows
1 to 20) and your drop down is in A2 of Sheet1:

Then in Sheet1 B2:

=VLOOKUP(A2,Sheet2!$A$1:$B$20,2,0) will give room name in B2
 
Thanks - that works!

Who knows is that's how we did it in the past - but that works just great!

J
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how do I generate lists in worksheets based on a master list works 10
Reformatting data and consolidating 2
Formatted cell column in drop down list 1
Excel 2007 drop down lists 6
Dependent drop down dynamic range formula, off sheet. 7
How can I create a Drop-down cell? 7
Drop Down Lists 2007 10
Drop down list 1

Back
Top