Results 1 to 2 of 2

MATCH *similar* strings and return adjacent column value

Threaded View

  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

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