+ Reply to Thread
Results 1 to 2 of 2

MATCH *similar* strings and return adjacent column value

  1. #1
    Registered User
    Join Date
    10-22-2009
    Location
    San Diego, California
    MS-Off Ver
    Excel 2003
    Posts
    1

    MATCH *similar* strings and return adjacent column value

    Here's the conditions: Two columns of business names in two different tabs (tab1 and tab2) within the same sheet. In tab1 column 'A' there are two company names: "Shoes and Things" and "Chocolate Master". In tab2 column 'A', the two company names are "Shoes & Things" and "Teds Lumber". tab1 also has a colum 'B' that contains business phone numbers. Objective: I need phone numbers in tab2 as well -- using a function within tab2 column 'B', I need to match "Shoes & Things" in tab2 with "Shoes and Things" tab1, and as a result, I need to display the phone number found in tab1 column 'B'

    Can you share a method for accomplishing this? [see sheet attached -- hopefully makes the objective clear]

    P.S. I have read about, and implemented, "FuzzyMatchOnWord" on mrexcel but it does not work in arrays. It's only useful if you can point explicitly to two distinct cells.
    Attached Files Attached Files

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: MATCH *similar* strings and return adjacent column value

    Welcome to the forum.

    Maybe http://www.excelforum.com/excel-gene...ng-errors.html will help.
    Entia non sunt multiplicanda sine necessitate

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1