|
|
#2
11-23-2011, 09:17 AM
|
||||
|
||||
I don't understand your layout very well but if your table is in, say A2:B10 on sheet 2 you can fetch the number using VLOOKUP like
Code:
=vlookup(A1,Sheet2!$A$2:$B$10,2,false) 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Drop Down List using SYMBOLS
|
sm5948 | Word | 2 | 09-28-2011 05:05 AM |
|
How to unlock Drop-Down list
|
ilkks | Word | 4 | 05-06-2011 12:19 AM |
| Create Drop Down List Box | hbradshaw | Word VBA | 0 | 09-27-2010 06:24 AM |
| Drop Down List and Functions (Linking) | sten | Excel | 0 | 03-17-2010 03:03 PM |
| Long List for drop down box | DLo99 | Word | 0 | 02-28-2010 08:07 AM |
Windows XP 
Office 2003
Threaded Mode