Hello awesome folk of the forum,

I've been having a little trouble with a formula to perform a partial match on a long list of cells. What I'm trying to do is to match the entries in column A with the closest possible match in column B (similar spelling but different arrangement of words) and return the result in column C. Both columns will have at least one word that matches i.e. Oxford, Manchester. As an example:

Column A
Oxford City Council
London Borough of Waltham Forest
Sheffield City Council

Column B
Sheffield
Oxford
Waltham Forest

Column C
Oxford
Waltham Forest
Sheffield

As you can see, the first word in some of the entries in column A match the entry I want in column B - but some don't (i.e. LBWF).

Apologies for not using a table, this was a bit rushed!