I am trying to set up a sheet on which I can select a value on a drop down list, and it will fill values from this list in another column. I've got 5 lists, from 8 to 460 values long, so I would like to select 'List 1' in cell A1 and have every value from List 1 appear in column B. Could anyone help?
I'll assume your lists are in a single 'table' with each list name as the header. You can then use something like this in B1:
=HLOOKUP($A$1,your_table,row(A2))
and drag that down as far as you need.
Pauley
--------
If I helped with your issue, I'd appreciate a rep bump (hit the '*' icon to the bottom left of this post).
Here is an example of Data Validation drop down lists. Named ranges are used as well as a lookup table to convert names with spaces into legal names for named ranges.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
Thanks guys, I thought there may have been a way to automatically populate the list without a lookup, but the HLOOKUP is a good idea. Cheers!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks