yes it is if you input range instead of cell reference
– MARK MY ANSWERJan 27 at 17:45

1

We don't have much to go on, Annan. And I have a feeling your actual data isn't going to adapt well to whatever we can offer sight unseen. That said, my gut is that I'd go with a =ArrayFormula(VLOOKUP(CELL_REFERENCE,QUERY({values, result1, result2}),{2,3},FALSE)) setup.
– Erik TylerJan 28 at 6:14

1 Answer
1

You may think that behaviour of IFS() is similar to IF() and reason of having IFS() is to avoid nesting of multiple IF() but that's not so true. Yes, there are some common baselines however, there is a major difference when it comes to arrays. IFS() in a combination of arrayed output expects arrayed input - that's why you got returned single-cell output instead of arrayed output.

let's say your IF() formula is like:

"converting" it into IFS() will return this (because cell A1 is not array/range):