Doesn't work for me in a horizontal, and certainly not in vertical, range.

"JE McGimpsey" wrote:

Try substituting commas for the semicolons. This works for me when used
in Insert/Define/Name:

=IF(!$A$1="Q1",{"Jan","Feb","Mar"},IF(!$A$1="Q2",
{"Apr","May","Jun"}))


In article ,
Tevuna wrote:

Excel allows a defined name to represent an array range or array constant. It
allows a name to represent a formula which is then evaluated to return a
value.
Why can I not define conditional arrays like these:
=IF(!$A$1=€Â�Q1€Â�,{€œJan€Â�;â‚ ¬Â�Feb€Â�;€Â�Mar€Â�},IF(!$A$1=€Â�Q 2€Â�, {€œApr€Â�;€Â�May€Â�;€Â�Junâ ‚¬Â�}))
=IF(!$A$1="Q1",!$A$2:!$A$4,IF(!$A$1="Q2",!$A$5:!$A $7))
When I try to enter their names in a vertical range, the first value is
returned in all cells.