+ Reply to Thread
Results 1 to 2 of 2

Access-style dynamic relationship table in ExCel? Possible?

  1. #1
    Registered User
    Join Date
    02-04-2016
    Location
    Kerala, India
    MS-Off Ver
    Office 2007
    Posts
    1

    Question Access-style dynamic relationship table in ExCel? Possible?

    I'm creating a workbook for a catering service. I'm a rookie when it comes to Excel so do excuse the amateurishness of my query.


    So, I've created a recipe cost calculator which has been designed so as to help the chefs determine how much quantity of each ingredient - which constitutes a particular dish - that they would require depending on the quantity ordered by the customers.

    I've arranged it so that each dish that the company offers has been given a separate worksheet into which the cost calculator is built. Inherent to each worksheet is the ingredients list which contain the costs of said ingredients. Logically, never are ingredients exclusive to a particular dish and ingredients will tend to overlap with different dishes. For example, you need Onions to make a beef burger as well as for a chicken curry. Furthermore, prices tend to fluctuate greatly in my part of the world and it would be tiresome to keep on changing the prices of the goods frequently. Now, instead of having to repeatedly type in the costs of the same ingredient for different dishes, I want a system where there is a central database of ingredients and ingredient cost where I can enter ingredient details, update prices, and from where the dish worksheets can source their cost information.

    Is this possible in Excel? If it is, a reply suited to my amateurishness would be greatly appreciated. :P

  2. #2
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: Access-style dynamic relationship table in ExCel? Possible?

    Yes, have a look at VLookup

+ 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. Replies: 0
    Last Post: 08-09-2013, 12:32 PM
  2. linking tables with access-style relation in excel
    By stephenjosephmurphy in forum Excel General
    Replies: 1
    Last Post: 01-23-2013, 09:19 PM
  3. [SOLVED] Idea of Access Relationship
    By boss1982 in forum Access Tables & Databases
    Replies: 15
    Last Post: 12-21-2012, 03:25 PM
  4. Access querying relationship to excel vba ?
    By datadk in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-11-2011, 03:29 PM
  5. Need dynamic title in pivot table in excel web access
    By SJMaye in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 10-12-2010, 01:36 PM
  6. Can you access the old-style Help Index using Excel 2003?
    By Dismayed in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 08-09-2006, 02:34 PM
  7. [SOLVED] Using Excel or Access for relationship webs
    By aspiringbodhisattva in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 03-23-2005, 01:06 PM

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