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
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.  

      • Woolich85's avatar
        Woolich85
        Copper Contributor
        Mar 31, 2022
        Hi Haytham,

        I know this was a while ago but you may be able to help.

        I've got your above solution working, but what if my columns are not side by side and three are columns in between that I wish to ignore?

        Example, I have my description in column B but my costs are in column E

Resources