D -
If you already have a worksheet with the data for the clubs and districts that data doesn't have to be in with the same worksheet as the data for your members.
Note this example. The district info is on sheet 2.
And now the formula changes to
=VLOOKUP(G2,Sheet2!$A$2:$B$11,2,0)
|