Forum Discussion
Help with Excel
I am trying to create a spreadsheet with multiple columns that have drop down menus. I have the menus and columns created but I need to figure out how to assign values to each option in each drop dow...
Ayoub,
Thank you for the reply. Just wanted to clarify the issue you are helping me resolve. Essentially, I each cell in this picture attached has a drop down list with multiple selections per list. I want to be able to make each item in these drop down lists have a cost associated to them and then when all options are chosen in a row, it will spit out a final cost in the last column labeled "Total Price", as shown in picture. Will the solution that you just gave me be able to do this?
It looks like the solution provided should work for your needs. It might be easier to implement the solution in Power BI instead of Excel.