making a drop-down list with two separate columns

[KeithAnuskewicz]

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

 

[Gord Dibben]

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

 

[Max]

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