Do a Lookup of the keyed-in value. See Vlookup, Hlookup, Lookup functions.

Tyro

"excel help acct" <excel help wrote in
message ...
I need to populate a heading on an excel spreadsheet based on a value keyed
by a user. It can be one of 12 values keyed in. How can I code the
heading
to appear based on the chouice selected by the user?