Thread: [Solved] Sorting a list of people by reference to another list
View Single Post
 
Old 06-07-2014, 07:50 PM
whatsup whatsup is offline Windows 7 64bit Office 2010 32bit
Competent Performer
  
Join Date: May 2014
Posts: 137
whatsup will become famous soon enough
Default
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)
Reply With Quote