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.
|