Excel365 - How to evaluate index with array?

Viewed 22

I'm using the following formula as a sub formula on excel365 :

enter image description here

when I press F9, then I have:

enter image description here

The problem is that if I use this formula as the Name Range it evaluates to return only "abc".

How to fix this?

0 Answers
Related