Nesting Functions like Index, Small, IF, Row & Column when using Excel 2016 and Older.
Also Nesting Functions like Textjoin & IF when using Excel 2019 and Newer.
Nesting these Functions together to return Multiple Values
=INDEX() - The INDEX function returns a value or the reference to a value from within a table or range.
=SMALL() - Returns the k-th smallest value in a data set. Use this function to return values with a particular relative standing in a data set.
=IF() - The IF function is one of the most popular functions in Excel, and it allows you to make logical comparisons between a value and what you expect.
So an IF statement can have two results. The first result is if your comparison is True, the second if your comparison is False.
=ROW() - Returns the row number of a reference.
=COLUMN() - The COLUMN function returns the column number of the given cell reference. For example, the formula =COLUMN(D10) returns 4, because column D is the fourth column.
=TEXTJOIN() - The TEXTJOIN function combines the text from multiple ranges and/or strings, and includes a delimiter you specify between each text value that will be combined. If the delimiter is an empty text string, this function will effectively concatenate the ranges.
DOWNLOADABLE RESOURCES