+ Reply to Thread
Results 1 to 4 of 4

Find a text in another table and return the TEXT - URGENT PLEEEEASE!

  1. #1
    Registered User
    Join Date
    01-12-2017
    Location
    United States
    MS-Off Ver
    Professional Plus 2013
    Posts
    1

    Unhappy Find a text in another table and return the TEXT - URGENT PLEEEEASE!

    Hello everyone,

    Here is my task for urgent:

    I have to list of companies, but their names are different, I need to match and be sure that the same customer belongs to both tables.

    Ex.: ABGO in table one, and ABGO. in table two. If I do a VLOOKUP it doesn’t find because in one there is a (.) and in the other no. How can I do it?
    I was thinking about taking part of the text and find in the another table, how is the function to find in another table (I can use mid to extract part of the text)

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,050

    Re: Find a text in another table and return the TEXT - URGENT PLEEEEASE!

    Welcome to the forum

    To best describe or illustrate your problem you would be better off attaching a dummy workbook. The workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

    To attach a file to your post,
    click advanced (next to quick post),
    scroll down until you see "manage file",
    click that and select "add files" (top right corner).
    click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

    Once the upload is completed the file name will appear below the input boxes in this window.
    You can then close the window to return to the new post screen.

    (also, I have a feeling that if you feel this is THAT urgent, you have also asked the same thing on other forums? If so, you need to provide a link to those forums here - and show those links on those other forums too)
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Find a text in another table and return the TEXT - URGENT PLEEEEASE!

    MID might work, it might not.
    If you can normalize the table two values by adding a helper column and fixing the variances, that might work. Hard to suggest anything blindly.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

  4. #4
    Forum Contributor
    Join Date
    01-05-2017
    Location
    New York
    MS-Off Ver
    Office 2016
    Posts
    206

    Re: Find a text in another table and return the TEXT - URGENT PLEEEEASE!

    If one has dots and one doesnt, put a SUBSTITUTE in the VLOOKUP. For example =VLOOKUP(SUBSTITUTE(A2,".",""),'Your table array',X,0).

    Put this in the table that has the dots and the substitute automatically removes all dots and vlookups whatever is left.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 4
    Last Post: 01-18-2015, 04:52 PM
  2. Replies: 10
    Last Post: 09-18-2014, 09:36 AM
  3. Replies: 3
    Last Post: 09-15-2014, 07:56 PM
  4. Formula to find and return text string within a cell full of text strings
    By LightingPop in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-03-2013, 11:45 PM
  5. Replies: 2
    Last Post: 09-07-2013, 07:50 PM
  6. Replies: 7
    Last Post: 01-24-2013, 06:55 PM
  7. [SOLVED] Find Specific Text in Text String and Return Value in Adjacent Column
    By watchouse in forum Excel General
    Replies: 2
    Last Post: 07-11-2012, 03:53 PM

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