Sorting a list of people by reference to another list

whatsup · #1 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)

Darkiness · #2 06-08-2014, 03:11 AM

I've got to thank you for your patience on this.
I have been using a dummy sheet to try and work out the method and I have tidied that up and attached it.
the sheet probaby explains it better than my narrative

ScottA · #3 06-08-2014, 03:55 AM

Darkiness

You are really close. What you need to do (easiest way) is put all of your club names in a single column with your districts in a second column right next to it. See Columns N & O.

Now you can use the formula whatsup provided:

Quote:

Originally Posted by whatsup

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.

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