+ Reply to Thread
Results 1 to 3 of 3

How to pull info from one table and use it to multiply in another table

  1. #1
    Forum Contributor
    Join Date
    11-13-2013
    Location
    California
    MS-Off Ver
    Excel 365 Apps for enterprise
    Posts
    180

    How to pull info from one table and use it to multiply in another table

    Hello,

    I'm trying to set up a formula that will take the cost per from the Ingredients tables, multiply it by the amount in the recipe tables (Each on its own tab), and give me the cost in the recipe table under the Cost column. The Blondies tab is a completed table, but I manually selected the cells. Death By Chocolate is blank for costs. I would love a formula to put here to streamline the calculations.

    Thanks!
    Attached Files Attached Files

  2. #2
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,213

    Re: How to pull info from one table and use it to multiply in another table

    Please try at D2
    =VLOOKUP([@Ingredient],Ingredients,5,0)*[@Amount]

  3. #3
    Forum Contributor
    Join Date
    11-13-2013
    Location
    California
    MS-Off Ver
    Excel 365 Apps for enterprise
    Posts
    180

    Re: How to pull info from one table and use it to multiply in another table

    Looks like it works like a charm! Thank you!!

+ 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. [SOLVED] Pull info from on page's table, based on the product name in that table.
    By Natejss in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-06-2019, 06:14 PM
  2. Replies: 6
    Last Post: 06-03-2019, 03:19 PM
  3. Macro to fill 1st table with info from 2nd table. 2nd table search with 2 conditions
    By Ribeiro.JD in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-17-2016, 02:03 PM
  4. Use Data Validation List To Pull Info From Table
    By hack4u in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-25-2016, 09:20 AM
  5. [SOLVED] Pull out multiple values from table
    By bull699 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-15-2016, 03:40 PM
  6. [SOLVED] Multiple Look Ups to return an info from a table
    By pleasesmile in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-10-2013, 01:26 PM
  7. [SOLVED] How to pull extra info into Pivot table report
    By MLK in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-21-2006, 08:25 PM

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