I've manged to split the two teams into seperate cells, my VLookup fails
now because there a space at the end of each team name. Can this be
removed or can VLookup do a near match instead of exact match?

Middlesbrough - Bolton
Charlton - Newcastle
Man Utd - Birmingham

Rik
:)


--
Rikuk
------------------------------------------------------------------------
Rikuk's Profile: http://www.excelforum.com/member.php...o&userid=26559
View this thread: http://www.excelforum.com/showthread...hreadid=526321