How can I get Excel to show this?????

[mcr1]

In cell A1, I have a drop down menu with 3 names in it, (Davis, Jones
Smith) When I select on of their names I want cell A2 to show the cod
name that I have given for that person. For example, in cell A1
select Jones, I want A2 to automatically show Broom, the code name
have given Mr. Jones.

Mile

 

[David McRitchie]

You mean for it to disappear when it is no longer
selected, you would have to use an event macro.

But a comment box would do something similar.

If this is homework, I think you would have been
given a little more to go on. Like the presence of
a table somewhere else.

As an Event macro you could change the font color
in to or from black or white, but selecting that column
would show everything.

 

[Dave Peterson]

Can you build a cross reference table (on another worksheet???)?

If yes, visit Debra Dalgleish's site for instructions for =vlookup().
http://www.contextures.com/xlFunctions02.html