Forum Discussion
Solved
Trying to integrate ROW function in index and match to retrieve multiple values.
I am having issues understanding the concept of extracting a list of data from a criteria using Excel 2016 and 365. See attach file. I was trying to use index and match, with row function to ach...
- I see... Tks.
Table1 is the range with the green filled header row. Table1[@] is the structured reference notation for the current record of the table and, typed anywhere in line with the table, will return a range reference to a single record. The function ROW( ) defaults to the current row, so it could be used without any cell references.
I see... Tks.