Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Selection of drop down list directs auto population of other cell
I am guessing that this is a rather easy task but I am stumped at how to
accomplish a desired function in excel. I have two columns of data, with the second column (same rows) having a value assoicated with the first column. I created a drop down list on the spreadsheet that gives the user the options in column 1. I want the box next to their selected column 1 list item to automatically populate with the cooresponsing value assocaited with the list item. E.g. you have item 1,2,3 in a column and an associated price for item 1 of $10, item 2 of $20 etc in the column next to the number. In the input area, if the user selects item 1 from the drop down list, the cell next to that choice automatically populates with $10. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Selection of drop down list directs auto population of other cell
Use VLOOKUP which stands for vertical lookup and search for a value in the
first column of a table array and returns a value in the same row from another column in the table array. Try the below formulas with a similar data and try changing the name in Cell C2 ColA ColB ColC ColD Heading1 Heading2 1 One 1 =formula 2 Two 3 Three 4 Four 5 Five C2 is a drodown list In place of formula (in cell D2) =VLOOKUP($C$2,$A$1:$B$7,2,FALSE) If this post helps click Yes --------------- Jacob Skaria "Maj J Schwartz" wrote: I am guessing that this is a rather easy task but I am stumped at how to accomplish a desired function in excel. I have two columns of data, with the second column (same rows) having a value assoicated with the first column. I created a drop down list on the spreadsheet that gives the user the options in column 1. I want the box next to their selected column 1 list item to automatically populate with the cooresponsing value assocaited with the list item. E.g. you have item 1,2,3 in a column and an associated price for item 1 of $10, item 2 of $20 etc in the column next to the number. In the input area, if the user selects item 1 from the drop down list, the cell next to that choice automatically populates with $10. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return the cell reference of the drop down list selection. | Excel Worksheet Functions | |||
drop down list that changes cell color upon selection | Excel Discussion (Misc queries) | |||
Linking a selection in a drop down list to a calc in another cell | Excel Worksheet Functions | |||
Selection of Drop down list that allows you to go to a particular cell | Excel Worksheet Functions | |||
Drop-down list & auto-population of cells | Excel Worksheet Functions |