+ Reply to Thread
Results 1 to 3 of 3

Using Excel as a Database

  1. #1
    Forum Contributor
    Join Date
    12-06-2015
    Location
    Hong Kong
    MS-Off Ver
    2010
    Posts
    357

    Using Excel as a Database

    Dear all,

    I have a challenge of using Excel as a Database, where user can select the items and rates by different suppliers.

    The condition ; i have
    1. Different city (now is 4 cities)
    2. Different supplier(now is 3 suppliers)
    3. Supplier rates (all submitted in same format)


    Now i want to do is , for the user
    • Select the city
    • Select the supplier
    • Select the services they provide; their rates will be returned

    How can i do it ? I have attached on what i did
    I can not figure it out how i can incorporate the "Supplier" into the filtering


    Appreciate your help



    Eric
    Attached Files Attached Files

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Seattle, WA, USA
    MS-Off Ver
    MS Office 365 Excel 2016
    Posts
    14,454

    Re: Using Excel as a Database

    Hi Eric,

    Each row of your data needs to have a: City, Supplier, Service, Rate then it can work.

    The above seems like a lot of extra typing but this is how your data must look for it to be a valid database.

    Your supplier tab needs the data arranged like the above suggests. The way it is now can't do what I think you want/need.

    Marv
    Hope this helps.
    One test is worth a thousand opinions.
    Click the * below to say thanks.

  3. #3
    Forum Contributor
    Join Date
    12-06-2015
    Location
    Hong Kong
    MS-Off Ver
    2010
    Posts
    357

    Re: Using Excel as a Database

    Dear Marvin

    Thanks for your comment

    I have a 2nd thought

    I use a "work around"method, to concentrate the supplier and services, and Index and Match this "concentrated"coloumn

    See attached.

    It seems work but i hope there is a better way.
    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)

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