The range size of INDEX and MATCH functions

Опубликовано: 04 Март 2025
на канале: Google Workspace Tutorial
53
6

The range size of INDEX and MATCH functions.
The INDEX range consists of 9 rows and 6 columns.
This MATCH returns the number of the row.
Its range should be 9 rows as the INDEX range.
This MATCH returns the number of the column.
Its range should be 6 columns as the INDEX range.