conditional headings

[excel help acct]

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?

 

[Tyro]

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

Tyro

 

[Gary''s Student]

Use =VLOOKUP()

See Excel Help on this function

 

[ryguy7272]

Most likely, your answer is contained in this link, if not, post back:
http://www.contextures.com/xlDataVal13.html


Regards,
Ryan--

 

[Pete_UK]

Assume the user enters a value between 1 and 12 inclusive into cell
A1. You could use this in another cell to return your heading:

=CHOOSE(A1,"One","Two","Three","Four","Five","Six","Seven","Eight","Nine","Ten","Eleven","Twelve")

Of course, you should substitute the headings you want for the
"numbers".

Hope this helps.

Pete