It would be good to get the equivalent capability of the Excel INDEX(table, row, column) functionality, for tables in the same page, but also for tables in other pages (although I understand then it might have to become a report-xxxx macro).
The input parameters should be injectable, and the result as well (into another macro). What I am really after would be the Excel INDEX(table, MATCH(), MATCH()) approach, where the first MATCH looks into the first column and matches a value to find a row#, and the second MATCH looks in the column headers and find the column, and then the result is the value that is in the intersection.
Hosting platform | Server |