Extract column from table (Excel) with subcategorys

[ksk_10594232]

Hi

I want to extract a column with data from different tables, where each table contains several subcategorys. See example below (and attached file). Is this possible to do in mathcad? 

For example, by selecting "Table 1", "Subcategory 3" and section "C" I want to extract a column containing the right set of data. 

Thanks in advance! 

[ksk_10594232]

Forgot to attach! 🙂

[Perez]

Hello @ksk_10594232 , I've attached a solution that should work for you. There may be several ways to solve the problem, but the method I've provided is straightforward to understand and implement.

[Werner_E · Accepted solution]

The attached file may help.

[ksk_10594232]

Thanks to both of you! 🙂