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