+ Reply to Thread
Results 1 to 4 of 4

Search within a Range using data from a Range

  1. #1
    Registered User
    Join Date
    12-14-2014
    Location
    WV, USA
    MS-Off Ver
    2013
    Posts
    6

    Search within a Range using data from a Range

    I have a two spreadsheets/workbooks with data in them and I'm trying to use one that has everything organized and identified to tag rows in the other one which is basically just a dump of around 6000 rows of IP addresses.

    I've spent all day and I just can't figure out how to use a range of cells as a "lookup_array" every function I try to use only allows a singe cell to be selected or a value entered.

    Is it even possible to make a formula that would search a huge list of IP addresses and tag specific rows using a range of cells on another sheet?


    All the examples I can find seem to indicate you can only search for a specific value and I need to be able find anywhere from 5 - 255 values

  2. #2
    Forum Guru Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,249

    Re: Search within a Range using data from a Range

    What does your required outcome look like? Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

  3. #3
    Registered User
    Join Date
    12-14-2014
    Location
    WV, USA
    MS-Off Ver
    2013
    Posts
    6

    Re: Search within a Range using data from a Range

    Sorry it took so long for a response I can't really use the computer until my kids are asleep. So using the random data in the spreadsheet I uploaded as an example...

    What I was trying to do was make a formula to copy down the A column that would search "B2:B1281 in Sheet1" using "A2:A256 in Sheet2" and return "Sheet2 A1" when found. Then I gave up and tried using COUNTIF to just return something so I could filter the sheet and copy over the formula to enter the owner myself.

    I would just change the range and column in the Sheet2 part of the formula and rinse and repeat until I had every owner in the spreadsheet identified.
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    12-14-2014
    Location
    WV, USA
    MS-Off Ver
    2013
    Posts
    6

    Re: Search within a Range using data from a Range

    Just wanted to put this out there in case someone else needed the same solution. It's pretty easy to modify and add new named ranges to search with in the same module.

    Please Login or Register  to view this content.
    Last edited by devildawg; 12-19-2014 at 02:31 PM.

+ 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. [SOLVED] Modify VBA Code Search Hilight from 1 range to multiples range?
    By david gonzalez in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-26-2014, 08:04 PM
  2. Search large date range with narrow filetered range
    By druth in forum Excel General
    Replies: 14
    Last Post: 08-02-2014, 09:01 AM
  3. Replies: 4
    Last Post: 09-24-2013, 08:57 AM
  4. Search range of strings with a range of keywords and highlight matches
    By efillner in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-12-2013, 04:07 PM
  5. Replies: 0
    Last Post: 01-19-2005, 12:06 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