+ Reply to Thread
Results 1 to 2 of 2

Search box and Filter

  1. #1
    Registered User
    Join Date
    12-13-2019
    Location
    Michigan, United States
    MS-Off Ver
    365
    Posts
    9

    Search box and Filter

    Short version: Looking to use a "searchbox", or just a cell for entry to search a second sheet(In the same workbook) and only pull rows that contain the partial match of the "searchbox" cell.
    i.e.
    Search.PNG

    EDIT: Going to be a bit more explanative I think.

    Currently in my Sheet 1 in cell D8, I have this formula that references D7
    Please Login or Register  to view this content.
    for a search option as follows:
    Capture46.PNG

    However when I drag and copy the row down, I get this error:
    Capture47.PNG

    The end goals is the first image, including the nearby rows all in the same table, so Sheet2!Range A:C technically. Only searching in Column A.
    There are about 25,000 entries as well, as a note.
    Is there a way I can copy this down further, or a better way in general?

    Thank you
    Last edited by rendon115; 03-06-2020 at 02:14 PM.

  2. #2
    Forum Guru Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    11,136

    Re: Search box and Filter

    Administrative note

    As the FILTER function is not a 2010 function , please update your profile as necessary to properly reflect the exact version(s) of Excel your question relates to. Members tailor answers based on your Excel version.

    Thanks
    Be very, very careful using IFERROR ! It hides ALL errors which is not always what you want to get correct results

+ 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. Search (filter search) a date value
    By navafolk in forum Excel General
    Replies: 6
    Last Post: 10-26-2018, 02:32 AM
  2. Replies: 4
    Last Post: 11-08-2014, 04:57 AM
  3. Replies: 2
    Last Post: 10-07-2013, 04:57 AM
  4. [SOLVED] Macro/s to create Search Bar to filter to search terms entered activated by Command Button
    By JasonRay in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-08-2013, 03:44 PM
  5. search for a name and then filter on it
    By Migraine in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-05-2009, 02:28 PM
  6. Great Combo Filter/Search form, cant get DATE filter to integrate. HELP
    By fau5tu5 in forum Access Programming / VBA / Macros
    Replies: 4
    Last Post: 05-18-2009, 05:05 PM
  7. Advance filter search does not filter an exact match
    By cfiiland in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-10-2005, 08:05 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