+ Reply to Thread
Results 1 to 7 of 7

Build a Ingredient table based on two table

  1. 12-11-2016, 08:00 AM #1
    francisdsa is offline
    Registered User
    Join Date
    11-17-2016
    Location
    Copenhagen
    MS-Off Ver
    2010
    Posts
    6

    Build a Ingredient table based on two table

    I have following two table

    Item Quantity sold per day and a table with ingredient used by Item in the below attachment
    Input.PNG

    Could someone help me with formula where i can automatically look into ingredient and multiply with quantity to create below table

    output.PNG


    Somehow using Formula i could list the value
    =IFERROR(INDEX(Inventory!$F$1:$AZ$1; MATCH(0; COUNTIF($A$1:A1;Inventory!$F$1:$AZ$1&"") + IF(Inventory!$F$1:$AZ$1="";1;0); 0)); "")
    Ingredient
    Salami
    Egg
    Cheese


    I need help!

    Thanks
    Reply With QuoteRegister To Reply
  2. 12-11-2016, 08:11 AM #2
    francisdsa is offline
    Registered User
    Join Date
    11-17-2016
    Location
    Copenhagen
    MS-Off Ver
    2010
    Posts
    6

    Re: Build a Ingredient table based on two table

    I am amateur in Excel and this is the attached excel sheet to know how far i managed to reach...
    Now i want to create Ingredient table

    Francis Check table.xlsx


    Thanks in advance for help.
    Reply With QuoteRegister To Reply
  3. 12-11-2016, 08:27 AM #3
    Jacc is offline
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2,883

    Re: Build a Ingredient table based on two table

    Like this maybe

    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Attached Files Attached Files
    <----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left

    If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
    I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.
    Reply With QuoteRegister To Reply
  4. 12-11-2016, 11:59 AM #4
    francisdsa is offline
    Registered User
    Join Date
    11-17-2016
    Location
    Copenhagen
    MS-Off Ver
    2010
    Posts
    6

    Re: Build a Ingredient table based on two table

    Thank you so much Jacc!!!!!!!!!!!
    Reply With QuoteRegister To Reply
  5. 12-11-2016, 12:05 PM #5
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,480

    Re: Build a Ingredient table based on two table

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    NB:     as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  6. 12-11-2016, 02:03 PM #6
    Jacc is offline
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2,883

    Re: Build a Ingredient table based on two table

    Good to hear it works!
    Reply With QuoteRegister To Reply
  7. 12-11-2016, 02:13 PM #7
    francisdsa is offline
    Registered User
    Join Date
    11-17-2016
    Location
    Copenhagen
    MS-Off Ver
    2010
    Posts
    6

    Re: Build a Ingredient table based on two table

    I was looking for the option on mobile...now i found it but only through laptop..thanks for the tips Aligw.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Need to build a Macro that can dynamically add rows to a table based on criteria
    By vbanoobz in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-05-2014, 06:39 PM
  2. How to build a Loan table with a Pivot Table
    By Julio Lescano in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 02-18-2014, 11:20 AM
  3. how to return top ten values and build a new table without using pivot table
    By cloudno9 in forum Excel General
    Replies: 4
    Last Post: 11-18-2013, 11:59 AM
  4. [SOLVED] Build Table using selected fields from Table of data
    By amartin575 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-01-2013, 01:45 PM
  5. Build a TOC with Headings within a table
    By Toomay in forum Word Formatting & General
    Replies: 1
    Last Post: 07-04-2011, 06:50 AM
  6. Macro to build pivot table based on another pivot table
    By tcowen61 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-31-2009, 10:41 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1