| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
pick from list and automatically enter corresponding cell
I'm trying to create a simple product order form. I have my product
selections and their corresponding pricing in 2 adjacent columns in the second sheet of my workbook. I have a dropdown menu for selecting the product choice, and I want the corresponding price in the cell adjacent to that product to automatically populate on the order form. I've tried LOOKUP, VLOOKUP, and MATCH formulae functions w/o success. It can't be that complicated, can it?! Your help and suggestions are much appreciated in advance. B |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help required with VBA program to automatically enter data from a validation list. | Excel Programming | |||
| pick from 'drop down list' OR enter text in cell | Excel Worksheet Functions | |||
| Automatically executing a macro when A pick list item is selected | Excel Programming | |||
| how do i get a drop down pick list in a cell | Excel Worksheet Functions | |||
| Making pick list conditional on selection from previous pick list | Excel Discussion (Misc queries) | |||
Threaded Mode
