|
|
#5
06-07-2014, 07:50 PM
|
|||
|
|||
Well, if that's what you want ...
 What does your list of clubs look like? Assuming the clubs are listed in one column (AA) and the districts in the following (AB) use VLOOKUP() H2 =VLOOKUP(G2,$AA$2:$AB$1000,2,0) Adjust the red part of the formula to the area were actually the clubs and districts are listed and copy the formula down the column. If you don't get it working describe were data is located, or load up a short example of the file (with personal data deleted) 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 How to import list from Excel into drop-down list into word
|
ahw | Word VBA | 43 | 02-28-2020 08:11 PM |
|
List Style Numbering picks up out of order number from LATER list
|
spthomas | Word | 12 | 12-16-2013 05:23 PM |
| Creating a list and sorting alphabetically. | irvsax | Word | 4 | 09-04-2013 11:47 PM |
|
Sorting numerically in recipient list
|
greengauge | Mail Merge | 2 | 05-19-2013 09:58 AM |
| Need to delete 'field code changed' in my reference list | leb | Word | 4 | 05-04-2013 12:25 AM |
Windows 7 64bit 
Office 2010 32bit
Threaded Mode