Using Excel Functions to return Multiple Values

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


MultipleValues-01
.xlsx
Download XLSX • 11KB

403 views0 comments