You could use VLOOKUP to display the description corresponding to the value.

If value "AA" is entered in A1 then in B1 put:

=Vlookup(A1,sheet2!A1:B50,2,false)

In Sheet2 in columns A & B set up a table of Values (in column A) and
description (in columnB); change range to suit.

To allow for values not found use:

=if(iserror(Vlookup(A1,sheet2!A1:B50,2,false)),"", Vlookup(A1,sheet2!A1:B50,2,false))

HTH

"meegan" wrote:

ok, I was asked to make a value, lets say AA have a drop box that means
mislocation of part. So that when you type AA you will have the drop box
come down telling you what it means. I have no idea how to do this though.
can someone plesae help me!