Forum Discussion
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 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?
6 Replies
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
Thanks Haytham Amairah on the right track. What if the table is on another page? also how do you label the table?
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
