|
|
#6
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) 
|
| 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 |
Windows Vista 
Office 2007
Threaded Mode