Variation on dependant Lists problem

[andyp161]

Hi,

Is it possible to programme Excel so that if you enter a particula
value in A1 it will enter an associated text in A2. For instance, I a
trying to create a stock-control sheet. Each piece of stock has a cod
and a description. I would like to be able to enter the code in colum
A, which will automatically enter the description in column B. I kno
how to create dependant lists using data validation and wondered i
there was a variation on this function that would solve my problem.

Many thanks

And

 

[Debra Dalgleish]

You can use a VLookup formula to return a value from a table. There are
instructions in Excel's Help, and here:

http://www.contextures.com/xlFunctions02.html