+ Reply to Thread
Results 1 to 5 of 5

Excel Tables - Formulas to pull data from

  1. #1
    Registered User
    Join Date
    10-18-2009
    Location
    Colorado
    MS-Off Ver
    Excel 2007
    Posts
    2

    Excel Tables - Formulas to pull data from

    I have a Excel Table that will be sorted/identified by the first column of every row. In the Table, there are numerous columns calculating values for each unique item across the row. This will be a large inventory table. The calculations will adjust based on a unit value of 1, and if the unit value is changed calculations go through the rows

    I want to accomplish several things:

    1) Pull data to another portion of the sheet based on,
    a) Selecting a unique item that comes from a drop down list based on unique item identifier in the table
    b) pull values related to the unique item and put in cells near the drop down list (I tried an =if function but did not have any luck
    =IF(G1=ZillaRac[Item Name],ZillaRac[MSRP],"MSRP Not Calculated") but it resulted in #value!

    2) If possible by selecting my unique identifier, insert a unit multiplier that would go into the Excel Table and adjust the values calculated in the table to be brought back up to the cells in part 1.

    Any assistance would be appreciated! Thanks!
    Last edited by DonkeyOte; 10-18-2009 at 03:47 AM.

  2. #2
    Registered User
    Join Date
    10-18-2009
    Location
    Colorado
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Excel Tables - Formulas to pull data from

    solved it w/ the =vlookup function

  3. #3
    Registered User
    Join Date
    06-02-2008
    Location
    Manitoba, Canada
    MS-Off Ver
    Excel 2010 & 2007
    Posts
    15
    sorry learning
    Last edited by yvonnecat; 11-21-2009 at 07:43 PM. Reason: delete

  4. #4
    Forum Guru teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,364

    Re: Excel Tables - Formulas to pull data from

    yvonnecat, please read the forum rules, which you've agreed to follow when you registered, and then start your own thread.

  5. #5
    Registered User
    Join Date
    06-02-2008
    Location
    Manitoba, Canada
    MS-Off Ver
    Excel 2010 & 2007
    Posts
    15
    sorry just learning
    Attached Files Attached Files
    Last edited by yvonnecat; 11-21-2009 at 07:45 PM. Reason: delete

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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