locked
Excel Search Facility RRS feed

  • Question

  • I am currently compiling a archive Database in which I want the end user to be able to search and pull up entire rows based on any entry within that row. The Columns are as so:

    Test House - Certificate Number - Standard/Directive - Application Covered - Model - Date - Page No.

    within the Date column there are hyperlinks leading to certification documents that need to be accessed but end user should be able to search a specific model/test house/standard and find all the information they want.

    The search formulas I have found only highlight or provide numbers based on how many matches the search criteria finds.

    I basically want a miniature google at the top of the database to filter out all unneeded documents based on what is typed within it leaving a short table with all the matching rows that contain the search parameter.

    Big ask I know but anyone out there know what to do?

    Wednesday, January 20, 2016 9:36 AM

Answers

  • Re: just the right stuff

    Excel has a built-in "Auto Filter" that may do what you want.
    It is found on the Ribbon in the  Data (tab) | Sort & Filter (group).
    It might look lke this...



    '---
    Jim Cone
    Portland, Oregon USA
    https://goo.gl/IUQUN2 (Dropbox)
    (free & commercial excel add-ins & workbooks)

    Thursday, January 21, 2016 2:16 AM
  • Hi Sean Hickman,

    Based on your description, my understanding was that you have a Workbook which contain several data (for example: Test House - Certificate Number - Standard/Directive - Application Covered - Model - Date - Page No.) Then you want your end users can get several information (for example: model/test house/standard) based on the Date they enter.

    Is my understanding correct?

    If yes, you can use Index and Match formula to get your result:

    =INDEX('Main table'!E:E,MATCH('End user'!A2,'Main table'!F:F,0))

    You can download this sample file from this link: http://1drv.ms/1nohBBW

    If my understanding is incorrect, please provide more information about your issue.

    You can also send a sample file about your problem to our email address:

    ibsofc@microsoft.com
    Please Note: Please add the URL of the case in the email subject or body.

    Any updates please let me know, I'm glad to help and follow up your reply.

    Regards,

    Emi Zhang
    TechNet Community Support


    Please mark the reply as an answer if you find it is helpful.

    If you have feedback for TechNet Support, contact tnmff@microsoft.com.
    Thursday, January 21, 2016 3:02 AM

All replies

  • I would ask the experts in an Excel forum.

    http://answers.microsoft.com/en-us/office/forum/office_2010-excel/

    Wednesday, January 20, 2016 11:39 AM
  • Re: just the right stuff

    Excel has a built-in "Auto Filter" that may do what you want.
    It is found on the Ribbon in the  Data (tab) | Sort & Filter (group).
    It might look lke this...



    '---
    Jim Cone
    Portland, Oregon USA
    https://goo.gl/IUQUN2 (Dropbox)
    (free & commercial excel add-ins & workbooks)

    Thursday, January 21, 2016 2:16 AM
  • Hi Sean Hickman,

    Based on your description, my understanding was that you have a Workbook which contain several data (for example: Test House - Certificate Number - Standard/Directive - Application Covered - Model - Date - Page No.) Then you want your end users can get several information (for example: model/test house/standard) based on the Date they enter.

    Is my understanding correct?

    If yes, you can use Index and Match formula to get your result:

    =INDEX('Main table'!E:E,MATCH('End user'!A2,'Main table'!F:F,0))

    You can download this sample file from this link: http://1drv.ms/1nohBBW

    If my understanding is incorrect, please provide more information about your issue.

    You can also send a sample file about your problem to our email address:

    ibsofc@microsoft.com
    Please Note: Please add the URL of the case in the email subject or body.

    Any updates please let me know, I'm glad to help and follow up your reply.

    Regards,

    Emi Zhang
    TechNet Community Support


    Please mark the reply as an answer if you find it is helpful.

    If you have feedback for TechNet Support, contact tnmff@microsoft.com.
    Thursday, January 21, 2016 3:02 AM