+ Reply to Thread
Results 1 to 5 of 5

Need help with Excel search "engine".

  1. #1
    Registered User
    Join Date
    07-22-2014
    Location
    Alberta, Canada
    MS-Off Ver
    Office 2007
    Posts
    2

    Need help with Excel search "engine".

    Ok so here's my dilemma (sorry if this makes no sense at all). I'm trying to create my own searchable database where I can punch in text/information into a cell and have excel do all the work and find the information for me.

    I have a table with a few thousand rows and eight columns. What I'm trying to do is have excel take the info that I enter into my "search" cell and find all the rows from my table that contain that info and place them above the table, making it easy to search through so I can find the row of info that I need.

    I have tried the LOOKUP function but it would only pull the first two columns... I may be doing something wrong I'm not sure. Any ideas?

  2. #2
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,647

    Re: Need help with Excel search "engine".

    Hi Mattaio,
    Welcome to the Forum.

    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
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

  3. #3
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Need help with Excel search "engine".

    http://www.excelforum.com/the-water-...-question.html
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  4. #4
    Registered User
    Join Date
    07-22-2014
    Location
    Alberta, Canada
    MS-Off Ver
    Office 2007
    Posts
    2

    Re: Need help with Excel search "engine".

    Ok I have attached the basic "search engine" that I'm trying to use. My goal is to be able to type something into the "search" box and have all data pulled from the table at the bottom and then placed into the middle section so it would be easier to filter through. I would need each row of the table to stay together.
    Excel Search.xlsx

  5. #5
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,647

    Re: Need help with Excel search "engine".

    Try this Array Formula. Since this is an array formula so you need to confirm it with Ctrl+Shift+Enter instead of just Enter. (i.e. after pasting the formula in B11, press F2 (Function Key), hold down the Ctrl+Shift together and then press Enter. When an array formula is entered correctly, you will notice in the formula bar that the formula gets surrounded by the Curly Brackets and if you don't see the curly brackets in the formula bar, retry to enter the formula as an array formula by pressing F2, holding down the Ctrl+Shift and pressing Enter then.)

    In B11
    Please Login or Register  to view this content.
    and then copy the formula across to I11 and down as far as needed.

    Is this what you are trying to achieve?
    Attached Files Attached Files

+ 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] Emulate Excel 97 getopenfilename "Advanced" find including "Search subfolders"
    By FORTRANguru in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-06-2014, 08:21 PM
  2. 7 nested IF statements with a SEARCH added IF(ISNUMBER(SEARCH({"INSUR","AP REFUND"}
    By michaelproctor001 in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 12-10-2013, 02:13 PM
  3. Replies: 8
    Last Post: 10-17-2012, 02:39 PM
  4. search directory for excel-files and put A136 from tab "1"-"20" in a table
    By Wim_VDW in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-30-2012, 10:33 AM
  5. =IF(ISERROR(SEARCH("insurance",A125,1)),"","*")
    By cynichromantique in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-31-2006, 02:45 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