Add table lookup macro

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.

  • Ron de Vries
  • Jan 13 2019
  • Needs review
Hosting platform Server
  • Attach files