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