Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
making a drop-down list with two separate columns
I have made a drop-down list of different items (text). I want to have each
item's respective price (currency) populate the adjacent column after that item is picked from the list. I first tried imbedded conditional "if" statements where if the text chosen on the list was equal to the text in a particular cell, the contents of another cell (the price) would be displayed. This worked well for me until I got past 7 imbedded "if" statements for the particular cell; then I would get an error. Since I need to do this for more items, I tried to make a drop-down list from the two columns (item description and price), but found out you can only make a list from a single column or row. Any suggestions? Thanks, Keith |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
making a drop-down list with two separate columns
Dropdown list in A1 of sheet1
On sheet2 column A your items Column B your price for each item In sheet1 B1 enter =VLOOKUP(A1,Sheet2!A:B,2,FALSE) Gord Dibben MS Excel MVP On Tue, 13 Jan 2009 13:47:01 -0800, KeithAnuskewicz wrote: I have made a drop-down list of different items (text). I want to have each item's respective price (currency) populate the adjacent column after that item is picked from the list. I first tried imbedded conditional "if" statements where if the text chosen on the list was equal to the text in a particular cell, the contents of another cell (the price) would be displayed. This worked well for me until I got past 7 imbedded "if" statements for the particular cell; then I would get an error. Since I need to do this for more items, I tried to make a drop-down list from the two columns (item description and price), but found out you can only make a list from a single column or row. Any suggestions? Thanks, Keith |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
making a drop-down list with two separate columns
You could use a vlookup to simplify things ..
Assume the ref table is set up in A1:B1 down in Sheet2 (eg: Item-Price) Then in Sheet1, Assume droplists (to select values in Sheet2's col A) are in A2 down Put in B2, copied down: =IF(A2="","",VLOOKUP(A2,Sheet2!A:B,2,0)) Col B will return the required matching values from Sheet2's col B -- Max Singapore http://savefile.com/projects/236895 Downloads:22,500 Files:370 Subscribers:66 xdemechanik --- "KeithAnuskewicz" wrote: I have made a drop-down list of different items (text). I want to have each item's respective price (currency) populate the adjacent column after that item is picked from the list. I first tried imbedded conditional "if" statements where if the text chosen on the list was equal to the text in a particular cell, the contents of another cell (the price) would be displayed. This worked well for me until I got past 7 imbedded "if" statements for the particular cell; then I would get an error. Since I need to do this for more items, I tried to make a drop-down list from the two columns (item description and price), but found out you can only make a list from a single column or row. Any suggestions? Thanks, Keith |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Making a drop down list read info from another tab / worksheet | New Users to Excel | |||
Add separate colors to values in drop down list | Excel Discussion (Misc queries) | |||
Making wider drop down List for Filter | Excel Worksheet Functions | |||
Making data validation drop down list wider | Excel Discussion (Misc queries) | |||
Making a drop down list/column | Excel Worksheet Functions |