Did I thank you? If not - Thanks!

"Tom Ogilvy" wrote:

create a table of codes and explanations

In B2 for example put in a formula

=if(A2<"",vlookup(A2,Table,0,2),False),"")

where table would be something like

sheet2!A1:B30

--
Regards,
Tom Ogilvy


"zan123" wrote in message
...
Example: If a code (i.e., 1, 2, 3, etc.) is placed in column A, can the
choice of the code in column A assign a predetermined entry (always the
same
for each code) in column B? If so how do you assign each "code" the
specific
statement that will follow in column B?

I.E. Placing #1 in column A with automatically (and always) put "blue
eyes"
in column B.