Complex Formula

I am looking for a formula to go into G2 that finds the combined sum in column D that is adjacent to the product in column C, but for the choice of product to be dictated by the product name in F2. So formula needs to be clever enough to change the volume if the name in F2 changes. I have used =Vlookup(F2,C1:G7,2,FALSE) and several iterations of it but I feel like vlookup isn’t the answer for my question.

Thanks in advanced for looking into this! (I’m still learning the beauty of Excel so be gentle)

Description   Example 1
  Column C Column D Column E Column F Column G     Column C Column D Column E Column F Column G
1 Product Volume   Product Total Volume   1 Product Volume   Product Total Volume
2 Aaa 9000   Product name here Formula here   2 Aaa 7000   Aaa 7000
3 Bbb 9000         3 Bbb 9000      
4 Bbb 9000         4 Bbb 9000      
5 Ccc 9000         5 Ccc 9000      
6 Ccc 5000         6 Ccc 5000      
Example 2   Example 3
  Column C Column D Column E Column F Column G     Column C Column D Column E Column F Column G
1 Product Volume   Product Total Volume   1 Product Volume   Product Total Volume
2 Aaa 7000   Bbb 18000   2 Aaa 7000   Ccc 14000
3 Bbb 9000         3 Bbb 9000      
4 Bbb 9000         4 Bbb 9000      
5 Ccc 9000         5 Ccc 9000      
6 Ccc 5000         6 Ccc 5000      

By: Roger

41 thoughts on “Complex Formula

  1. Anastrozol kaufen

    F*ckin¦ awesome things here. I¦m very happy to look your article. Thank you a lot and i’m taking a look forward to touch you. Will you kindly drop me a mail?

  2. Buy CBD Topicals Online

    Please let me know if you’re looking for a article writer for your site. You have some really great articles and I feel I would be a good asset. If you ever want to take some of the load off, I’d love to write some articles for your blog in exchange for a link back to mine. Please shoot me an e-mail if interested. Thanks!

  3. Acheter Melanotan 2 en ligne

    Greetings! I know this is kinda off topic but I was wondering which blog platform are you using for this site? I’m getting fed up of WordPress because I’ve had issues with hackers and I’m looking at alternatives for another platform. I would be fantastic if you could point me in the direction of a good platform.

  4. anabole steroide kaufen

    I feel this is one of the such a lot vital information for me. And i am satisfied studying your article. However should remark on some common things, The web site taste is great, the articles is in point of fact great : D. Good activity, cheers

  5. Acheter Adipex Retard en ligne

    Its like you read my mind! You appear to know so much approximately this, like you wrote the ebook in it or something. I believe that you simply can do with some to force the message house a little bit, however instead of that, that is magnificent blog. A great read. I’ll certainly be back.

  6. Injectables Anabolic Steroids For Sale

    What i do not realize is actually how you are not really much more well-liked than you might be now. You’re so intelligent. You realize therefore considerably relating to this subject, produced me personally consider it from so many varied angles. Its like men and women aren’t fascinated unless it is one thing to do with Lady gaga! Your own stuffs great. Always maintain it up!

  7. Bestellen

    I was wondering if you ever thought of changing the structure of your website? Its very well written; I love what youve got to say. But maybe you could a little more in the way of content so people could connect with it better. Youve got an awful lot of text for only having one or two pictures. Maybe you could space it out better?

  8. Phentermine online kaufen

    It’s perfect time to make some plans for the long run and it’s time to be happy. I have read this publish and if I may I wish to counsel you some fascinating issues or suggestions. Maybe you can write next articles relating to this article. I want to read more issues approximately it!

  9. ig

    It’s going to be finish of mine day, except before end I am reading this great
    piece of writing to increase my knowledge.

  10. CBD For Lip Care

    What i don’t realize is in truth how you’re not actually a lot more neatly-favored than you may be right now. You’re so intelligent. You understand thus considerably with regards to this topic, produced me in my opinion consider it from a lot of various angles. Its like women and men aren’t involved unless it’s something to accomplish with Girl gaga! Your personal stuffs nice. All the time handle it up!

  11. sling tv best package 2020

    I’m truly enjoying the design and layout of your website.
    It’s a very easy on the eyes which makes it much more enjoyable for me to come
    here and visit more often. Did you hire out
    a designer to create your theme? Excellent work!

  12. Rory Kottraba

    Thanks a bunch for sharing this with all of us you actually know what you are talking about! Bookmarked. Kindly also visit my website =). We could have a link exchange contract between us!

  13. sling tv

    Spot on with this write-up, I honestly feel
    this web site needs a great deal more attention. I’ll probably be returning to see more, thanks for the

  14. sling tv

    Hi, I do believe this is a great web site. I stumbledupon it 😉 I am
    going to revisit yet again since I book marked it.
    Money and freedom is the best way to change, may you be rich and continue to help others.

  15. sling tv

    What’s Taking place i am new to this, I stumbled upon this I have found It positively useful and it has helped me out loads.

    I hope to contribute & assist other users like its aided me.
    Good job.

  16. free trial

    An interesting discussion is worth comment.
    There’s no doubt that that you need to write more about this topic, it might not
    be a taboo subject but usually folks don’t speak about such issues.
    To the next! All the best!!

  17. coconut oil

    Wow! This blog looks exactly like my old one! It’s on a entirely different subject but it has
    pretty much the same layout and design. Great choice of colors!

  18. ps4 games

    Everyone loves what you guys are usually up too.
    Such clever work and coverage! Keep up the superb works guys I’ve incorporated you guys to my own blogroll.

  19. ps4 games

    Having read this I believed it was rather enlightening.

    I appreciate you spending some time and energy to put this informative article together.
    I once again find myself spending way too much time both reading and commenting.
    But so what, it was still worthwhile!

  20. plenty of fish dating site

    Great items from you, man. I have remember your stuff
    previous to and you are just extremely fantastic. I actually like what
    you have bought right here, really like what you’re stating and the way through which you say it.
    You are making it entertaining and you still take care of
    to keep it wise. I can’t wait to read far more from you.
    This is actually a tremendous web site.


    Hi there i am kavin, its my first occasion to commenting anywhere,
    when i read this post i thought i could also make comment due to this sensible article.

Comments are closed.