Data in column predetermined by what has been entered in previous

[Guest]

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.

 

[Guest]

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

 

[Tom Ogilvy]

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

 

[Guest]

Thanks!

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

 

[Guest]

Thanks!

 

[Guest]

Did I thank you? If not - Thanks!

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

 

[Gord Dibben]

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