SOLVED

Assigning value to the names in a dropdown list

%3CLINGO-SUB%20id%3D%22lingo-sub-1793396%22%20slang%3D%22en-US%22%3EAssigning%20value%20to%20the%20names%20in%20a%20dropdown%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1793396%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20anyway%20to%20assign%20values%20to%20the%20elements%20of%20a%20dropdown%20list%3F%20So%20that%20when%20I%20select%20an%20option%20from%20the%20list%2C%20it%20automatically%20feed%20the%20value%20to%20the%20formula%3F%20Please%20see%20the%20attached%20file.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EA%20solution%20will%20be%20much%20appreciated.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%2C%3C%2FP%3E%3CP%3ETooba%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1793396%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Etraining%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1793439%22%20slang%3D%22en-US%22%3ERe%3A%20Assigning%20value%20to%20the%20names%20in%20a%20dropdown%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1793439%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F826924%22%20target%3D%22_blank%22%3E%40MTooba%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20may%20try%20this...%3C%2FP%3E%3CP%3EIn%20G4%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3E%3DIF(E4%3D%22%22%2C%22%22%2CIFERROR(VLOOKUP(E4%2CTable1%2C2%2C0)%2C0)*F4)%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3Eand%20then%20copy%20it%20down.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1793441%22%20slang%3D%22en-US%22%3ERe%3A%20Assigning%20value%20to%20the%20names%20in%20a%20dropdown%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1793441%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F394231%22%20target%3D%22_blank%22%3E%40Subodh_Tiwari_sktneer%3C%2FA%3E%26nbsp%3BThank%20you%20very%20much.%20I%20think%20your%20formula%20solves%20my%20current%20problem.%20I%20might%20get%20back%20to%20you%20if%20there%20is%20another%20problem.%20Really%20appreciate%20your%20quick%20response.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1793502%22%20slang%3D%22en-US%22%3ERe%3A%20Assigning%20value%20to%20the%20names%20in%20a%20dropdown%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1793502%22%20slang%3D%22en-US%22%3E%3CP%3EYou're%20welcome%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F826924%22%20target%3D%22_blank%22%3E%40MTooba%3C%2FA%3E!%20Glad%20it%20worked%20as%20desired.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1876014%22%20slang%3D%22en-US%22%3ERe%3A%20Assigning%20value%20to%20the%20names%20in%20a%20dropdown%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1876014%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F394231%22%20target%3D%22_blank%22%3E%40Subodh_Tiwari_sktneer%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20see%20the%20attached%20file.%20I%20am%20trying%20to%20calculate%20the%20cost%20in%20terms%20of%20categories.%20Is%20there%20any%20way%20to%20combine%20the%20results%20of%20different%20categories%20in%20the%20final%20sheet%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20very%20much%20for%20taking%20the%20time.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20regards%2C%3C%2FP%3E%3CP%3ETooba%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

Hi,

 

Is there anyway to assign values to the elements of a dropdown list? So that when I select an option from the list, it automatically feed the value to the formula? Please see the attached file.

 

A solution will be much appreciated.

 

Best,

Tooba

6 Replies
Highlighted
Best Response confirmed by MTooba (Occasional Contributor)
Solution

@MTooba 

You may try this...

In G4

=IF(E4="","",IFERROR(VLOOKUP(E4,Table1,2,0),0)*F4)

and then copy it down.

 

Highlighted

@Subodh_Tiwari_sktneer Thank you very much. I think your formula solves my current problem. I might get back to you if there is another problem. Really appreciate your quick response.

Highlighted

You're welcome @MTooba! Glad it worked as desired.

Highlighted

@Subodh_Tiwari_sktneer 

Hi,

 

Please see the attached file. I am trying to calculate the cost in terms of categories. Is there any way to combine the results of different categories in the final sheet?

 

Thank you very much for taking the time.

 

Best regards,

Tooba

Highlighted

@MTooba 

 

You may try this formula on Sheet3

=IF(C6="","",SUMIF(Sheet2!$F$4:$F$10,C6,Sheet2!$H$4:$H$10))

Or you may also insert a Pivot Table like one I inserted on Sheet3 in the attached to get the desired output.

 

 

Highlighted
Hi,

Thank you very much. It is very helpful.

Best,
Tooba