#1
|
|||
|
|||
How to populate multiple columns with a single dropdown selection
Tracking a bunch of different reports on a spreadsheet, blah blah blah.
My boss has asked me to put additional info on the spreadsheet. His suggestion was to use lots and lots of columns, which offends my delicate sensibilities. The attached sheet will let you see the problem more clearly. on sheet 2, I have a 3 column list. on sheet two, those three columns are in the middle of the spreadsheet. Right now, I have a drop down that allows me to select an option for the Column A. What I would like is to be able to select an item for Column A, and have the spreadsheet populate columns A, B, and C based on the list on sheet 2. Can that be done? If so, how? Thanks |
#2
|
||||
|
||||
d4:
=VLOOKUP($C4,Sheet2!$B$4:$D$9,2,0) e4: =VLOOKUP($C4,Sheet2!$B$4:$D$9,3,0) |
#3
|
|||
|
|||
Thank you!
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Multiple Selection Dropdown list | ajanson | Word VBA | 36 | 07-15-2019 08:16 PM |
Selection of a dropdown creates another dropdown wih the list | krishnamurthy.ka2810 | Word VBA | 1 | 04-26-2018 11:44 PM |
Link listbox (with multiple columns) to bookmark based on selection | dsjk9190 | Word VBA | 5 | 01-29-2015 11:28 PM |
Macro to populate a text form field based on dropdown selection | koloa | Word | 0 | 10-20-2011 11:52 AM |
moving data from single to multiple columns? | mzimmers | Excel | 3 | 08-23-2010 08:20 AM |