Array Formulas / Array Concepts Summary (desired and attempted)

amit_bhola 

I suspect you have taken on too much in trying to present a complex topic with a large number of exceptions in a single table.  You will have benefitted in its production but, for someone looking for information, it makes for difficult reading.

The first thing I would suggest is to deal with Excel 365 and legacy spreadsheets separately; they are very different beasts despite the fact that 365 is backward compatible.  I would also recommend developing the ideas using mainstream functions before addressing the 'odd-ball' functions such as INDIRECT.  There, lori_m's work on function signature should be valuable.

One function that you could use is XLOOKUP which is capable of returning a range reference or an array (as is INDEX).  As an example, the returned values of

= XLOOKUP({"Feb";"March"}, textRange, numericRange)
and
= XLOOKUP("Feb", textRange, numericRange):XLOOKUP("March", textRange, numericRange)

may look similar but nesting within ISREF( ) or using it within COUNTIFS( )

= COUNTIFS(
    XLOOKUP({"Feb";"March"},textRange,numericRange),
    ">5")

= COUNTIFS(
    XLOOKUP("Feb", textRange, numericRange):XLOOKUP("March",textRange,numericRange), 
    ">5")

gives very different outcomes.

p.s. The names textRange and numericRange are simply your ranges held within cells A1:B4, but I haven't used direct referencing since 2015.