+ Reply to Thread
Results 1 to 6 of 6

Look up helps

  1. 07-25-2013, 12:16 PM #1
    Ben1985
    Ben1985 is offline
    Forum Contributor
    Join Date
    07-31-2012
    Location
    Derby, UK
    MS-Off Ver
    Excel 2013
    Posts
    138

    Look up helps

    Hey guys,

    I need a formula that finds a transaction within a list and then displays the Sales Total and Profit into a list.

    See example attached.

    Thanks for any help.

    BenexampleJuly2013.xlsx
    Reply With QuoteRegister To Reply
  2. 07-25-2013, 12:31 PM #2
    Sam Capricci
    Sam Capricci is offline
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.84 for Mac MS 365
    Posts
    8,504

    Re: Look up helps

    Is this what you are looking for?
    Attached Files Attached Files
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci
    Reply With QuoteRegister To Reply
  3. 07-25-2013, 12:49 PM #3
    Ben1985
    Ben1985 is offline
    Forum Contributor
    Join Date
    07-31-2012
    Location
    Derby, UK
    MS-Off Ver
    Excel 2013
    Posts
    138

    Re: Look up helps

    Hi,

    Unfortunately no, sorry if I was unclear. The total for the transaction is always in the row with no item, so in the first case the total for the order is H3. I'd like it to find the transactions amongst the days transactions and then display the transaction total.

    Thanks,
    Ben
    Reply With QuoteRegister To Reply
  4. 07-25-2013, 01:00 PM #4
    Sam Capricci
    Sam Capricci is offline
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.84 for Mac MS 365
    Posts
    8,504

    Re: Look up helps

    Hmmm, I think I'm seeing it. So you're saying you are not looking to do the sum on the "Sales Summary" worksheet but rather across from the cell in RMS Sales so that the total sales for 669108 would be in H3 and it would sum what's under H3 appropriate for 669108 (?) or sum other columns too such as col I and/or J? And the next would sum for 669109 in cell H6.
    AND, each would have their profits summed in cells N3 and N6 respectively?
    Sorry I'm a little fuzzy, just got out of the hospital Sunday and am still not thinking clearly.
    Reply With QuoteRegister To Reply
  5. 07-26-2013, 12:22 AM #5
    windknife
    windknife is online now
    Forum Expert
    Join Date
    04-14-2009
    Location
    Taiwan
    MS-Off Ver
    Excel 2016,2019,O365
    Posts
    2,017

    Re: Look up helps

    Try it,

    D4
    Please Login or Register  to view this content.
    copied to E4, copied down.

    HTH,
    WindKnife
    Reply With QuoteRegister To Reply
  6. 07-26-2013, 07:01 AM #6
    Ben1985
    Ben1985 is offline
    Forum Contributor
    Join Date
    07-31-2012
    Location
    Derby, UK
    MS-Off Ver
    Excel 2013
    Posts
    138

    Re: Look up helps

    Thanks Windknife, that works perfectly.

    Ben
    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. 2 little helps plz
    By Radonsheep in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 11-16-2006, 08:28 PM
  2. Need helps with a few Macros
    By Obi-Wan Kenobi in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-21-2006, 09:20 AM
  3. Helps with Macros
    By lennymos123 in forum Excel General
    Replies: 5
    Last Post: 05-04-2005, 03:06 PM
  4. Helps..
    By kphan78 in forum Excel General
    Replies: 0
    Last Post: 01-28-2005, 07:01 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1