ExcelBanter - LOOKING AT THE FIRST PART OF A CELL

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - LOOKING AT THE FIRST PART OF A CELL (https://www.excelbanter.com/excel-programming/318483-looking-first-part-cell.html)

LOOKING AT THE FIRST PART OF A CELL

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

LOOKING AT THE FIRST PART OF A CELL

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