Get table without knowing which row and column

[arina]

I have a table somewhere in excel. I want to get the table, but I don’t know which row and column it is located.

Based on the examples, I want to get the red text. But the table located at various place. The only thing that exact is the table header name which is unique and only one exist in the whole excel. The value “MANY” also unique.
test.xlsx (11.0 KB)

[Eric_Wong_Test (Eric Wong)]

Get_table.xaml (15.0 KB)

Sheet1

Sheet2

[ABHIMANYU_THITE1 (ABHIMANYU THITE)]

Hi @Eric_Wong_Test good solution, should work!