Tried to do that but once it came to trying i didnt really know what it meant.

It might be the way I have described it. In column G of the 25000 rows, there are the names of 356 clubs.

What I want to be able to do is to type in a formula which in non excel terms would translate as

"For each row where the cell in column G shows the words (Halifax, Leeds, Doncaster....York) then insert the H cell for that row the words District 1"

and then

"For each row where the cell in column G shows the words (Redruth, Torquay, Bristol, Taunton.... Bath) then insert the H cell for that row the words District 4"

and so on.

better still would be if I could make the formula "read" the list of clubs that belong to each district, rather than have to type them into the formula