Dropw down user form in Excel

[K E Senthilkumar]

Hi,

I have a list of 700 items on sheet2. The order of the column is like
partno,description, priceper unit.

In sheet1, i want a drop down list showing the items from sheet2. When i
choose the item, i want all the 3 columns to appear on my sheet1. So far i
used user forms to create a drop down list(shows 3 columns), can choose, but
i get only 1 column value in the cell. I want all the 3 cells to appear on
sheet1. How can i achieve this.

thanks for the replies.

Senthilkumar

 

[Corey]

You need to set EACH of the 3 columns in the List to what cell you require
them to be placed.

Corey....

 

[Dave Peterson]

Maybe you can use Data|Validation as the dropdown.

Say the cell that will contain the part number is in A2
Then in B2, you could use:
=if(a2="","",vlookup(a2,sheet2!a:c,2,false)
in C2:
=if(a2="","",vlookup(a2,sheet2!a:c,3,false)

See Debra Dalgleish's site for some nice notes:
http://contextures.com/xlDataVal01.html
and
http://contextures.com/xlFunctions02.html