Six Sigma Blackbelt wrote:
In my excel worksheet i have a drop down menu that displays codes, but i also
have the meaning of that code in another column. I want to be able to select
the from the drop down and it shows the correlating definition in the
adjacent cell. any clue on what formula can do this. thank you

Assuming your codes are in A1:A10 and your meanings are in B1:B10 and the drop
down is in C1 put the following in D1:

=VLOOKUP(C1,A1:B10,2,FALSE)