Value retrieval from the Multiple selection dropdown in excel

I am trying to make calculation from my dropdown menu. I have following dropdown in sheet 1 in my excel.

Category

AAA

BBB

CCC

DDD

 

In sheet 2, i have corresponding values for this dropdown.

Category

Value

AAA

1

BBB

2

CCC

3

DDD

4

 

I added VBA code for multiple selection and also added simple Vlookup formula to retrieve the value of category.

 

=VLOOKUP(E2;Sheet2!I2:J5;2;)

 

With the VBA code, i am able to select all three category and also remove the selected category later. But I am failing to retrieve the sum of selected category. For e.g. I want if customer chooses category AAA & CCC, he/she should be able to see sum as 4. Also if customer first chooses all three category and then removes one of the category then also the sum should get updated. I am not getting how do i update my Vlookup formula to get the sum.
By: Ruts

5 thoughts on “Value retrieval from the Multiple selection dropdown in excel

  1. ig

    Hi there just wanted to give you a quick heads up. The words in your content seem to be running off the screen in Firefox.

    I’m not sure if this is a formatting issue or something to do with
    internet browser compatibility but I figured I’d post to let you know.
    The style and design look great though! Hope you get the issue fixed soon. Kudos

  2. Carey

    Hello there! I could have sworn I’ve visited this web site before
    but after looking at some of the articles I realized it’s new to me.

    Anyways, I’m certainly pleased I came across it and I’ll be bookmarking it and
    checking back regularly!

  3. WaynePaymn

    I gain in value the info on your snare sites. Thanks a categorize. [url=http://de.global-box.net/lowenzahn-entgiftung/]löwenzahn entgiftung[/url]

  4. Herbertsuime

    The info is quite helpful. [url=http://machinalansu.pl/green-coffee-5k/]http://machinalansu.pl/green-coffee-5k/[/url]

Comments are closed.