| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating a Drop down list then linking another cell.
Can I create a drop down list in a cell? If yes, how do I do that?
Then after I create the drop down list I want it so that when I pick something from the drop down list the cell beside it will put in a price. Example: B1 B2 Reg $112.00 I want it to put the price in for me without me having to type it in. -- Alexa |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Creating a Drop down list then linking another cell.
You can use VLOOKUP to make that happen. The formula would look something
like this... =VLOOKUP(A1,B1:C5,2,0) Where A1 is where the drop down list is. Where column B is a list of the same things in the drop down list. Where column C is the respective prices of the things in the drop down. HTH Regards, Howard "Alexa M." wrote in message ... Can I create a drop down list in a cell? If yes, how do I do that? Then after I create the drop down list I want it so that when I pick something from the drop down list the cell beside it will put in a price. Example: B1 B2 Reg $112.00 I want it to put the price in for me without me having to type it in. -- Alexa |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating Drop Down List inside a cell? | Excel Discussion (Misc queries) | |||
| Linking a selection in a drop down list to a calc in another cell | Excel Worksheet Functions | |||
| Linking a cell to a drop down list | Excel Worksheet Functions | |||
| Creating a drop down list to change decimal value in another cell | Excel Worksheet Functions | |||
| Creating drop down list for multiple cell ranges | Excel Discussion (Misc queries) | |||
Linear Mode
