Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Making words in a list a value!!
I am trying to create a list that will generate a value in another column
once that word or phrase is chosen. Is this possible and how. Exp. In the drop down list I would chose Product, then in the price column the price automatically appears. |
#2
|
|||
|
|||
brco1, Much better than I could ever explain the process. Here's exactly what you need. http://www.contextures.com/xlFunctions02.html HTH -- Casey ------------------------------------------------------------------------ Casey's Profile: http://www.excelforum.com/member.php...fo&userid=4545 View this thread: http://www.excelforum.com/showthread...hreadid=470920 |
#3
|
|||
|
|||
brcol
You could use the VLOOKUP Function with a table of Products and Prices. See Debra Dalgleish's site for info. http://www.contextures.on.ca/xlFunctions02.html While you're there check out using Data Validation drop-downs for entering values to lookup. http://www.contextures.on.ca/xlDataVal01.html Gord Dibben Excel MVP On Mon, 26 Sep 2005 14:17:01 -0700, "brco1" wrote: I am trying to create a list that will generate a value in another column once that word or phrase is chosen. Is this possible and how. Exp. In the drop down list I would chose Product, then in the price column the price automatically appears. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Number to words literal | Excel Worksheet Functions | |||
list 1 has 400 names List 2 has 4000. find manes from list 1 on 2 | Excel Worksheet Functions | |||
find names on list 1 in list 2. list 1 4000 names list 2 400 name | Excel Worksheet Functions | |||
Drop down List problems | Excel Discussion (Misc queries) | |||
making used values fall from a list | Excel Discussion (Misc queries) |