Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional headings
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional headings
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional headings
Use =VLOOKUP()
See Excel Help on this function -- Gary''s Student - gsnu200765 "excel help acct" wrote: 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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional headings
Most likely, your answer is contained in this link, if not, post back:
http://www.contextures.com/xlDataVal13.html Regards, Ryan-- -- RyGuy "excel help acct" wrote: 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? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional headings
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 On Jan 11, 7:00*pm, excel help acct <excel help wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Headings | Excel Discussion (Misc queries) | |||
Can I invert a table so row headings are now column headings etc | Excel Worksheet Functions | |||
Headings | Excel Discussion (Misc queries) | |||
headings | Excel Worksheet Functions | |||
Excel row headings | Excel Worksheet Functions |