|
|
|
|
#1
01-10-2017, 04:08 PM
|
|||
|
|||
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) 
|
|
#2
01-11-2017, 12:59 AM
|
||||
|
||||
|
What do you mean by " a better way" ? A11 contains a drop down box as requested...
__________________
Using O365 v2503 - 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 |
| Thread Tools | |
| Display Modes | |
|
|
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 |
Windows Vista 
Office 2007
Hybrid Mode