Excel Help

#1
Hi,

I am trying to assign percentages to a dropdown list in Excel

I have specific industries that I want to assign percentages in the dropdown to.

An example would be:

Manufacturing = 10.6%
Business Services = 20.7%

I want to allow someone to pick their industry from the dropdown but get the numeric value in a calculation in the spreadsheet.

Thanks so much for any suggestions.

Best regards,

Matt
 
#3
Hi,

Thanks for your help. No I actually want it to tie to a dropdown menu that will tie the industry with a specific value. I want that value to then be used in a calculation in a cell below that will multiply that value with 3 others that are being inputted by an end-user.

Best regards,

Matt