+ Reply to Thread
Results 1 to 3 of 3

Excel giving out prices, taking in consideration of criteria

  1. #1
    Registered User
    Join Date
    07-14-2017
    Location
    Luxembourg
    MS-Off Ver
    2013
    Posts
    9

    Post Excel giving out prices, taking in consideration of criteria

    Good morning everyone, I'm having a little problem finding a solution for my cost simulation in Excel. Okay, imagine you have two products a T-Shirt and a pair of pants. Well that's the first criteria, then the two products you have them in two different sizes and colors which then is your second and third criteria. When all the criteria are clear I want Excel to spit out the correct price, does somebody know how to do that? I'm thinking of some sort of interactive drop down menu. Find here a scheme to understand my idea better : https://i.imgur.com/6r9GEBQ.jpg

    I hope somebody can help me and thank you for every tipp/idea!

  2. #2
    Valued Forum Contributor ranman256's Avatar
    Join Date
    07-29-2012
    Location
    Kentucky
    MS-Off Ver
    Excel 2003
    Posts
    1,173

    Re: Excel giving out prices, taking in consideration of criteria

    you would produce N records
    pants, large, Qty, Price, Blue
    pants, small, Qty, Price, brown
    tshirt, large, Qty, Price, white
    tshirt, small, Qty, Price, blue


    items from Product table
    items from ProdSize table (Price is here, child of Product)
    items from ProdColor table

  3. #3
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,057

    Re: Excel giving out prices, taking in consideration of criteria

    backdoor... since this is posted in access, can I assume you have tables in an access database already? If yes, what is the structure?
    Please help by:

    Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
    Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know

    There are 10 kinds of people in this world... those who understand binary, and those who don't.

+ 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. Conversion of text files to Excel in consideration of criterion
    By Ravi_Kadu in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 05-18-2017, 07:35 AM
  2. Replies: 2
    Last Post: 07-14-2015, 02:12 PM
  3. [SOLVED] Sum range without taking #N/A into consideration
    By Ramzes in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-21-2015, 08:31 AM
  4. pasting consideration between word & excel
    By vientito in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-01-2014, 10:58 AM
  5. Adding up Absent time taking lunch time into consideration
    By abrilabs in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-21-2013, 02:02 PM
  6. Replies: 3
    Last Post: 12-05-2012, 05:12 PM
  7. % to Volume Formula taking into consideration days worked
    By kwilliams5675 in forum Excel General
    Replies: 7
    Last Post: 04-20-2010, 03:26 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