+ Reply to Thread
Results 1 to 8 of 8

Find Hostname and Application from a list of IP address from Merged Cell

  1. #1
    Forum Contributor
    Join Date
    05-22-2015
    Location
    Malaysia
    MS-Off Ver
    2010
    Posts
    186

    Find Hostname and Application from a list of IP address from Merged Cell

    Hi,

    I have a raw data of IP address with includes (), /, : and words in a merged cells.
    Would like to find out the hostname and application name where the IP address is in single address and check against the merge cells.

    For better understanding, please refer to attached file.

    Would appreciate your assistance on how to solve this issue. Thank you.

  2. #2
    Valued Forum Contributor PFDave's Avatar
    Join Date
    05-17-2012
    Location
    Milton Keynes, England
    MS-Off Ver
    Excel 2013
    Posts
    1,067

    Re: Find Hostname and Application from a list of IP address from Merged Cell

    Hi no file attached.

    Please upload

  3. #3
    Forum Contributor
    Join Date
    05-22-2015
    Location
    Malaysia
    MS-Off Ver
    2010
    Posts
    186

    Re: Find Hostname and Application from a list of IP address from Merged Cell

    Hi

    Attached is the sample data for your understanding. Thank you.
    Attached Files Attached Files

  4. #4
    Forum Contributor
    Join Date
    05-22-2015
    Location
    Malaysia
    MS-Off Ver
    2010
    Posts
    186

    Re: Find Hostname and Application from a list of IP address from Merged Cell

    Hi,

    Really need your assistance to extract the IP addresses from the merged cells. Thank you.

  5. #5
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    2007, Office 365
    Posts
    11,806

    Re: Find Hostname and Application from a list of IP address from Merged Cell

    I am not sure I have interpreted the mission correctly, but try this in B12, then fill down and across.
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Dave

  6. #6
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2010
    Posts
    4,695

    Re: Find Hostname and Application from a list of IP address from Merged Cell

    Or try this ...

    =VLOOKUP("*"&$A12&"*",$A$3:$C$7,COLUMNS($A:B),0)

    Copy cross and down.

  7. #7
    Forum Contributor
    Join Date
    05-22-2015
    Location
    Malaysia
    MS-Off Ver
    2010
    Posts
    186

    Re: Find Hostname and Application from a list of IP address from Merged Cell

    That's awesome. Both formulas worked.
    Thank you FlameRetired and Phuocam.

  8. #8
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    2007, Office 365
    Posts
    11,806

    Re: Find Hostname and Application from a list of IP address from Merged Cell

    You are welcome. Glad they work. Thank you for the feedback and the rep.

+ 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. need a way to find the IP address from a hostname in excel
    By sdubicki in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-29-2014, 03:36 PM
  2. ip address in one column and capture hostname in adjacent column
    By addu in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-02-2012, 04:49 AM
  3. Looking for PING with Hostname and MAC address
    By blobberthrhino in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-16-2011, 06:26 PM
  4. Getting the Address of a merged cell
    By dude2007 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-19-2008, 01:06 AM
  5. [SOLVED] Dynamic cell address resolution in visual basic application?
    By John Carter in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-26-2006, 11:50 AM
  6. [SOLVED] Converting list of IP Addresses to list of Hostname
    By M. Eteum in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-23-2006, 02:20 PM
  7. Converting list of IP Addresses to list of Hostname
    By M. Eteum in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-23-2006, 02:20 PM
  8. [SOLVED] Get IP address for a remote computer based on its hostname
    By stabilo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-14-2006, 03:15 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