+ Reply to Thread
Results 1 to 2 of 2

Help in creating a reactive searchable database please!

  1. #1
    Registered User
    Join Date
    01-02-2013
    Location
    Missoula
    MS-Off Ver
    Excel 2010
    Posts
    1

    Exclamation Help in creating a reactive searchable database please!

    I would like to be able to create a reactive, searchable database. I have data that will be broken down into two divisions: Origin and Destination States. I would like to type in an Origin State, then a Destination State, and then have the document provide results for matching data. For example, if company 1 is in the origin state, but not destination state, its data will not be shown in the search result. However, if company 2 is listed in both the Origin State and Destination State, its data will be listed. Any suggestions?

    Addition - Attached is a small example of the worksheet that I would like to create. In the "SEARCH" tab, I would like to enter the Origin and Destination States. Ideally, the search would yield all appropriate matches. In this example, if I entered Alabama as the Orign State, and Arizona as the destination, the search would provide the following match:

    GreenLine
    H&M Bay
    Refrigerated Express

    Thank you!
    Attached Files Attached Files
    Last edited by Livesey; 01-02-2013 at 01:04 PM.

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    25,411

    Re: Help in creating a reactive searchable database please!

    Yes, but post an example workbook first, then we can see how you data is laid out and give you a solution specific to your needs. The FAQ describes how to attach a file to your posts.

    Pete

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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