Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
cell value to populate based on changing value in another cell
Hello,
I am populating a pricing list. A combo box displays a product. I need the price to display in a separate cell. How do I get the individual prices to display based on the product chosen in the combo box? please understand that i am at a beginner level when you offer suggestions. Thank you kindly |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
cell value to populate based on changing value in another cell
Hi TLC,
Well, isn't it always funny how things work out? Sometimes things that would seem to be easy turns out to be difficult. So, let me get this straight, you have a drop down list, select an item from that list and you want the price of that item to pop up? Let's say A1 is your drop down list (assuming that you have this info defined). Also, let's assume that you have 3 items in your drop down list, guns, butter, and bicycles. In another cell (say B1, maybe off to the side or something, used as a "scratch pad"), put in the formula: =value(A1) This will store the value as selected from the list. In another cell, where you want the price to be listed, use a VLOOKUP and have your guns, butter, and bicycle prices arranged already. example: a b c 1 gun gun =vlookup(b1,a5:b7,2) 2 3 4 5 gun $300 6 butter $2 7 bicycle $100 Hope that helps, cheers! -Kevin- "TLC" wrote: Hello, I am populating a pricing list. A combo box displays a product. I need the price to display in a separate cell. How do I get the individual prices to display based on the product chosen in the combo box? please understand that i am at a beginner level when you offer suggestions. Thank you kindly |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto populate this cell based on what's typed in this cell | Excel Discussion (Misc queries) | |||
Populate Cell based on selected Cell. | Excel Discussion (Misc queries) | |||
How to populate a cell with numeric value based on textselected from pull down in adjacent cell? | Excel Worksheet Functions | |||
auto populate cell based on previous cell drop down list selectio. | Excel Discussion (Misc queries) | |||
How can I populate an Excel cell based on the data in another cell | Excel Worksheet Functions |