#1
|
|||
|
|||
Help w/ Drop Down Lists
Hello, I am not sure if this is even possible to do but i'm keeping my fingers crossed. basically lets say I have data in row 1-5 and col A-D in one sheet1. In sheet2 I want to have a drop down list set up so that when select the item in the drop down list that corresponds to cell A1 in sheet 1, the other data that is in the remainder of the rows and columns would populate as well. Does that make sense? So say in the drop down menu I have names, and in the table setup for the drop down list I would have the name, address, age etc. So when I select a name, I want to have the rest of the info corresponding to that name populate on its own. Is this possible? I am not good with VBA so can this be done without using code? I was thinking of doing it with VLOOKUP but the problem i am having is that some of the names would be the same so the formula would not be able to tell the difference. I am not a pro at excel, so there might be an easy way to do this or it might be complicated. I am not sure.. Any help it will be highly appreciated. thanks. |
#3
|
|||
|
|||
Not really. I saw this already. If you look below, What i am trying to do is select John from a drop down list and the rest of the info would populate. That is john's age and gender as well as the 2 names under him and their age and gender. This isn't what im using it for but its the simplest example i can think of.
Name Age gender john 21 m mike 2 m jill 6 f |
#4
|
||||
|
||||
Perhaps using an INDEX/MATCH combination
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#5
|
|||
|
|||
|
#6
|
|||
|
|||
Not sure this is a better way, but you could try in B11 copied over and down...
=VLOOKUP($A11,$A$3:$C$5,COLUMNS($A$1:B$2),0) |
#7
|
||||
|
||||
What do you mean by " a better way" ? A11 contains a drop down box as requested...
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
Tags |
drop down list, vlookup |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Drop down lists options | inq80 | Excel | 2 | 10-17-2014 08:05 AM |
Multiple Drop Down Lists in word | ali212006 | Word | 3 | 03-13-2013 12:16 PM |
Dependent drop down lists | bobbych | Word | 1 | 02-08-2013 04:38 PM |
Drop-down lists in Excel | Maureen | Excel | 1 | 11-10-2011 08:11 AM |
Drop Down Lists | Browett | Excel | 0 | 12-19-2005 04:20 PM |