+ Reply to Thread
Results 1 to 5 of 5

matching partial text within one cell to partial text within another

  1. #1
    Registered User
    Join Date
    03-03-2010
    Location
    San Francisco, CA
    MS-Off Ver
    Excel 2003
    Posts
    2

    matching partial text within one cell to partial text within another

    Hello!

    I am hoping you guys can help me out. I am trying to build a formula that matches specific text from 2 different cells, then pulls different criteria from each cell and matches it into a third cell.

    For example.

    In the first cell, along with other things, I have an IP address(e.g.15.158.15.15), a machine address(e.g. 1800.0529.c87f), and the interface they are connecting through(e.g. FastEthernet0/0).

    In the second cell, (also along with other things) I have a machine address and a port on a switch they are connected to(e.g. Fa0/1).

    What I want to do is using that common machine address within the 2 columns, find out which IP addresses are attached to which switch ports.

    I have attached an example spreadsheet.

    I have been pulling by hair out on this one, so any help you can offer would be truly appreciated.

    Thank you for your time!
    Attached Files Attached Files
    Last edited by Solstice; 03-03-2010 at 08:55 PM.

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    11,846

    Re: matching partial text within one cell to partial text within another

    Copy column A and B each to a new sheet. Use Data > text to columns to split the text into separate columns. Use a basic VLOOKUP...
    Attached Files Attached Files
    Ben Van Johnson

  3. #3
    Valued Forum Contributor JeanRage's Avatar
    Join Date
    03-02-2009
    Location
    Nice, France
    MS-Off Ver
    Excel 2003
    Posts
    705

    Re: matching partial text within one cell to partial text within another

    Hi Bob,

    You had already done most of the job ...
    See attached file ...

    HTH
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    03-03-2010
    Location
    San Francisco, CA
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: matching partial text within one cell to partial text within another

    Thank you both. That works great and has given me some ideas how to further streamline the process.

  5. #5
    Forum Guru martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: matching partial text within one cell to partial text within another

    doesnt show cdp neighbour detail give that info?
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

+ 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