lists urgent help needed

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
Back
Top