+ Reply to Thread
Results 1 to 4 of 4

Formula to find an IP address from one sheet and match with another excel workbook

  1. #1
    Registered User
    Join Date
    08-05-2013
    Location
    Hyderabad
    MS-Off Ver
    Excel 2007
    Posts
    13

    Formula to find an IP address from one sheet and match with another excel workbook

    Hi All,

    Need help. I have 2 Excel files - One file have the list of IP addresses (format xx.xx.xxx.xxx) and another sheet has all the other details in which the IP addresses are spread across different rows & columns in multiple sheets in the workbook.

    I want a formula where it can scan through the entire Workbook and tell me if that IP is present in the workbook or not and give me the Worksheet name in which the IP is present.

    Please help me at the earliest. I am looking at a formula only and not VB codes.

    Thanks & Regards,
    Siritvrs

  2. #2
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,637

    Re: Formula to find an IP address from one sheet and match with another excel workbook

    ctfl +F
    options> search within workbook
    search for
    *.*.*.*
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Registered User
    Join Date
    08-05-2013
    Location
    Hyderabad
    MS-Off Ver
    Excel 2007
    Posts
    13

    Re: Formula to find an IP address from one sheet and match with another excel workbook

    Hi, this is manual and this is not possible to do it as I have multiple sheets with each containing columns from A to AZ and rows more than 3000. I am looking for a formula.

  4. #4
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,637

    Re: Formula to find an IP address from one sheet and match with another excel workbook

    then dont see how you can do this without vb

+ 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. Find last column's address for Excel formula
    By icyrius in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-31-2013, 12:35 PM
  2. find a formula to autopopulate one workbook sheet to another workbook
    By Aleaghh00 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-06-2013, 03:43 PM
  3. Using a ADDRESS/MATCH with VLOOKUP to find a value in a table
    By stturn in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-05-2013, 02:42 PM
  4. Replies: 11
    Last Post: 10-14-2012, 01:03 PM
  5. Help! Formula to find the address of particular value in sheet
    By xcelion in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-13-2005, 07:41 AM

Tags for this Thread

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