I have made lists and have put them all in a drop down menu. I have about 95
items. The item number needs to go into one cell, then depending on the
number selected, it needs to give the correct item description in the cell
next to it, and then the item price in the next cell. All based on which
number is picked in the first one. I am having a tough time getting it to
work!
--
Amy T

If the item that you are selecting from the drop down menu is in a data table
and is unique to the data table, put that item in the left most column of the
data table and use the vlookup function to return the data that goes with it.
ie. =vlookup(A1,$A$50:$C$70,2,FALSE)

A1 is the item from the drop down menu that you are selecting, $A$50:$C$70
is the data table that has that item in the left most column, 2 is the number
of the column within that table that you want to return, FALSE makes sure
that the item matches perfectly (otherwise column 1 needs to be in ascending
order)

"Stbrnalt" wrote:

I have made lists and have put them all in a drop down menu. I have about 95
items. The item number needs to go into one cell, then depending on the
number selected, it needs to give the correct item description in the cell
next to it, and then the item price in the next cell. All based on which
number is picked in the first one. I am having a tough time getting it to
work!
--
Amy T

I have the same situation as stbrnalt. I have a drop down menu (cell S59)
that contains three lines; item 1, item 2, and item 3 (from a tabie in column
T and lines 52, 53, and 54). Item 1 is $1.00, 2 is $2.00 and 3 is $3.00
(from a table on col U, lines 52-54). How can I make the item in the drop
down automatically match the price?

"Brad Vogt" wrote:

If the item that you are selecting from the drop down menu is in a data table
and is unique to the data table, put that item in the left most column of the
data table and use the vlookup function to return the data that goes with it.
ie. =vlookup(A1,$A$50:$C$70,2,FALSE)

A1 is the item from the drop down menu that you are selecting, $A$50:$C$70
is the data table that has that item in the left most column, 2 is the number
of the column within that table that you want to return, FALSE makes sure
that the item matches perfectly (otherwise column 1 needs to be in ascending
order)

"Stbrnalt" wrote:

I have made lists and have put them all in a drop down menu. I have about 95
items. The item number needs to go into one cell, then depending on the
number selected, it needs to give the correct item description in the cell
next to it, and then the item price in the next cell. All based on which
number is picked in the first one. I am having a tough time getting it to
work!
--
Amy T