Forum Discussion
penn6602
Aug 09, 2025Copper Contributor
Vlookup with Index and Match, selecting from a single table of multiple tables
I'm struggling to find a solution for a formula to pull data from a specific table where there are multiple tables in a single worksheet. The example is, each table is a pay chart corresponding to a ...
BudgotMakinTots
Aug 14, 2025Iron Contributor
Use INDEX + MATCH + IF to filter specific table data, with the array formula forced to take effect.