Need help with returning selectable array

[mrblister]

Hello!
For the following formula, if posted in D1 as an array formula, would give the results in column D:

=TRANSPOSE(LINEST($B$1:$B$5,$A$1:$A$5^{1,2,3}))

A	B	C	D
1	1	3	8.25
2	50		-68.3929
3	10		179.3571
4	50		-114.8
5	100

I want to modify the formula so that I can enter the polynomial order in C1. Something like this following formula, but this gives me an error:

=TRANSPOSE(LINEST($B$1:$B$5,$A$1:$A$5^switch(C1,1,{1},2,{1,2},3,{1,2,3},4,{1,2,3,4},0)))

Can anyone assist?

 

[Fluff]

but this gives me an error:

What error?

 

[mrblister]

What error?

... Hmmm. I just ran it again and there is no error. I don't know why it didn't work before, but it does work now.

 

[Fluff]

Glad it's sorted & thanks for letting us know.

 

[mrblister]

Glad it's sorted & thanks for letting us know.

Appreciate you looking into it!