G
Guest
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=â€Q2â€, {“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.
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=â€Q2â€, {“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.