|
|
#3
10-17-2014, 08:05 AM
|
|||
|
|||
Hi,
MATCH function returns the position of the selected option in list, which is exactly what is needed in this case, we can use the position to associate a number to a selection. If we want to change the number associated to a selection, this can be done by simply rearranging the list! Test the attached file, let me know if this is what you needed. Cheers, 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| 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 |
| Locking Documents and Drop-Down Lists | Andrew H | Word | 2 | 11-04-2012 02:59 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 2010 32bit
Threaded Mode