+ Reply to Thread
Results 1 to 3 of 3

Search for cell value as substring in column and return matched cell value

  1. #1
    Registered User
    Join Date
    06-12-2009
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    3

    Search for cell value as substring in column and return matched cell value

    Hi all

    I am trying to find an excel function that allows me to search for a cell value in column of values in a different workbook. It should be able to match against part of the string in the different workbook and then return the full value of that cell. I can use control+F which finds these values within the string on the other workbook however there are 5k records so its too manual

    These are the cell values that I wish to look up

    Codes to Look Up.png

    This is the column where the look up table is held

    Look Up Column.png

    This shows the results that I would expect to see:

    Expected Results.png

    Any help would be greatly appreciated!

    thanks a lot

    James

  2. #2
    Forum Contributor
    Join Date
    12-26-2008
    Location
    India
    MS-Off Ver
    2007
    Posts
    122

    Re: Search for cell value as substring in column and return matched cell value

    Hi,

    If you could a sample excel sheet with dummy data and expected result, this would expedite results..

  3. #3
    Registered User
    Join Date
    06-12-2009
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Search for cell value as substring in column and return matched cell value

    Will do - thanks
    Attached Files Attached Files

+ 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