Try trimming the lookup value, like this

=VLOOKUP(TRIM(A2),I2:K45,2,FALSE)

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Rikuk" wrote in
message ...

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