Mar 30 2020 07:14 PM
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 drop down menu. I select (Car). Car has rate of $50 associated with it somehow. In cell B1 I put 10. In cell C1 the math result of Cells A1 & B1 being multiplied leaving $500.00.
How can this be done?
Mar 31 2020 04:28 AM - edited Mar 31 2020 04:29 AM
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
Mar 31 2020 08:38 AM
Thanks @Haytham Amairah on the right track. What if the table is on another page? also how do you label the table?
Mar 31 2020 08:50 AM - edited Mar 31 2020 08:51 AM
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
Mar 31 2020 09:10 AM
@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.
Mar 31 2020 08:48 PM
Mar 30 2022 05:44 PM