Hi
use
=VLOOKUP(A1&"*",'othersheet'!A1:B100,2,0)

--
Regards
Frank Kabel
Frankfurt, Germany

"lost!!" schrieb im Newsbeitrag
...
Help please....

Worksheet 1 has column A with town names in it - like Abbotsford
Worksheet 2 has column A with areas in it - containing town names -
like
Abbotsford District.

is there anyway to use Vlookup (or something else) to find the match
so that
I can pull other data from worksheet 2? I've been trying Vlookup but
because
Abbotsford is not the same as Abbotsford District it's not finding a
match.

thanks