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