Now we have:
The next step is to construct the array for INDEX to work with.
This can be translated literally as “return values from the named rangedatawhere values intempare less than 75”.
This array is returned to the INDEX function for itsarrayargument.
Finally, theINDEX functionreturns the last 3 entries from the array returned by FILTER.
The output from FILTER is dynamic.
If source data or criteria change, FILTER will return a new set of results.
The array can be one dimensional, or two-dimensional, determined byrowsandcolumnsarguments.
you’ve got the option to use INDEX to retrieve individual values, or entire rows and columns.
The MATCH function is often used together with INDEX to provide row and column numbers….
