LOOKING AT THE FIRST PART OF A CELL

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Deleting specific records 6
using part of a cell to sort a list into groups 2
VLookup in two Excel 2003 workbooks 3
Excel print area which only prints pages of worksheet which are active 0
Find a value in a sheet and replace it with another value if it matches 8
Set range, perform operation, set new range, repeat 1
Look up match and highlight 1
help with worksheet design 2

Back
Top