lists urgent help needed

M

mark stillman

Hi, im trying to set up a spread sheet for the tand c dept where i work and
we need a list that when an item is selected from it the cells next to it
should automatically show the part number and the weight of the units, any
ideas?
 
T

Toppers

Mark,
Look at "Data Validation" to generate your list and use VLOOKUP
to get the other data.

Create a table with item, part number and weight: let's say this table is
columns A to C of Sheet2 in rows 2 to 100.

In Sheet1 , cell A2 create your Data Validation:

Data=>Validation=>List=>Source: =Sheet2!A2:A100 (include "=")

in B2: =VLOOKUP(A2,Sheet2!$A$2:$C$100,2,0) .... get Product number

in C2: =VLOOKUP(A2,Sheet2!$A$2:$C$100,3,0) .. get weight

HTH
 
Top