Extract all text to the left of a hyphen ???

Hope it helps, you must have same criteria with your lookup table, like this one....

Criteria: Manchester United

but in your table: Manchester Utd

Yes it can be done with SEARCH or FIND Function but you have other similar team, like : Manchester City or more like, and your data in every team is unique, so its difficult to retrieve the results.. so the easy way is changing word "utd" with "United"

Cheers

you are right azumi, i will change it and seee how i go.

Cheers burdo

ok i have changed to the exactly the same text and trimed the text, however i still dont know how to match the data with the text.

Instructions are on page 2 of my file