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.

Check out the VLookup function in HELP.
HTH,
Gary Brown


"zan123" wrote:

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.

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.

Thanks!

"zan123" wrote:

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.

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.

Thanks!

"Gary Brown" wrote:

Check out the VLookup function in HELP.
HTH,
Gary Brown


"zan123" wrote:

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.

Sounds like VLOOKUP could do the trick.

For more on that Function see Debra Dalgleish's site.

http://www.contextures.on.ca/xlFunctions02.html

Also see Debra's site for info on Data Validation lists with drop-down box for
entering the code numbers.

http://www.contextures.on.ca/xlDataVal01.html

Might be useful.


Gord Dibben Excel MVP

On Wed, 23 Feb 2005 10:57:02 -0800, zan123
wrote:

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.