Take a look at VLOOKUP in Help.

In article ,
mark stillman wrote:

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?