Forum Discussion

mark_bates's avatar
mark_bates
Copper Contributor
Mar 31, 2020

Making drop down menu represent an item & cost

Hello.  What I need to do is create a drop down menu that has specific items in it that also reflect a cost. Then be able to take that cost and multiply it by another cell. Example Cell A1 is a dro...
excel
Haytham Amairah's avatar
Haytham Amairah
Silver Contributor
Mar 31, 2020

mark_bates

 

Hi,

 

You can create a table with each name and its associated value.

Then, in cell C2 use a lookup formula to return the associated value of the name in cell A2 and then multiply it by the value in cell B2.

 

 

Hope that helps

 

  • mark_bates's avatar
    mark_bates
    Copper Contributor
    Mar 31, 2020

    Thanks Haytham Amairah on the right track.  What if the table is on another page? also how do you label the table?

    • Haytham Amairah's avatar
      Haytham Amairah
      Silver Contributor
      Mar 31, 2020

      mark_bates

       

      You can move the table to a new sheet, and refer to it in the formula.

      To change the table name, select any cell of it, then go to Table Design >> Table Name as follows:

       

      Please note that the formula will update automatically with the new name.

       

      Regards

      • mark_bates's avatar
        mark_bates
        Copper Contributor
        Mar 31, 2020

        Haytham AmairahOk I got that part.  My Excel didn't have table design in the ribbon for some reason.  If you don't mind could you look at my Excel? On Sheet1, Cell A19 I need the drop down to select equipment from the Equip Page, Cell A1 (equipment description).  I also need for the rate on Equip, Cell B1 to go to Sheet 1, Cell B19.  This would make it so when I select a piece of equipment the rate for the equipment would automatically go to Sheet1, Cell B19.    Thanks for the help.  I have watched countless You Tube Videos and im spinning my wheels.  

Resources