| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
choose a product from a drop down list i need it to insert a p
Thanks that worked great.
"Ron Coderre" wrote: Hi, Barnzy Let's create one more range name..... On Sheet2 <insert<name<define Names in worktook: LU_Price Refers to: A1:B24 Now...on Sheet1 D12: =IF(COUNTIF(Units,A12),VLOOKUP(A12,LU_Price,2,0)," ") Note: if the list of products and prices will continue to grow, you may want to consider using Dynamic Range Names, which expand and contract to match the volumn of data cells. Once again, Debra Dalgleish has the topic covered at her website: http://www.contextures.com/xlNames01.html#Dynamic Does that help? (Post back with more questions) *********** Regards, Ron XL2002, WinXP "Barnzy" wrote: That all looks great but i have no idea how to use the code. I have figured out how to create a drop down list that refers to sheet 2 but can not figure the rest out. Please bear with me as i have only just started using excel. I will try to explain it. On sheet2 I have 2 columns. In column A Rows 1-24 is a list of products (that i have named "units") for a data validation list. In column B Rows 1-24 is the corresponding price of the units. such as B1 is the price of A1 and so on. Now on Sheet1 A12 is a drop down list (=units) Now i need Sheet1 D12 to show a related price to the product chosen in A12. Can someone hold my hand through this and help me wrap my head around this so I can understand it. Thanks "Barnzy" wrote: i need to know how to have a related price show up in column D when i choose a product from a drop down list in column B ex. B C D TTW036 $6495.50 I have about 30 differant products each with their own price. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return a price based on a customer from a drop down list | Excel Discussion (Misc queries) | |||
| Product list to match price list | Excel Discussion (Misc queries) | |||
| How do I choose from the drop down list in excel | Excel Discussion (Misc queries) | |||
| How do I insert A drop down dialog box as a 'list to choose from'? | Excel Worksheet Functions | |||
| Product Price List with 14k records, filter w/out using AutoFilter | Excel Worksheet Functions | |||
Hybrid Mode
