Forum Discussion
INDEX-XMATCH and result table sorting
I generated a list of numbers (one number to a row) derived from a table of numbers (six numbers to a row) using a vertical and horizontal index and match function:
=INDEX(Table13[[21/08/2023]:[26/08/2023]],XMATCH('Entry-by-line'!C2,Table13[Name text only]),XMATCH('Entry-by-line'!B2,Table13[[#Headers],[21/08/2023]:[26/08/2023]]))
When I sort the results by any column headers other than the column that this formula is in (for example by B or C), the result at row 2 in the column with the formula does not change to match the corresponding changed reference data in cells B2 and C2. The result in the formula in row 2 follows the reference cells to their new row in the sorted table.
What must I do so that I can sort the data by any header after the formula is applied?
4 Replies
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
Here is a link to Google Drive for the sample workbook with the formula.
https://docs.google.com/spreadsheets/d/17LzV22-7A-8o88Tp0vC7V4--qiSTo_Pe/edit?usp=sharing&ouid=104816640649703394847&rtpof=true&sd=true
