I have a problem not sure how to solve it. I want to create a formula which will display the content of the table based on cell value.
I have for e.g two tables Box1, Box2
Box1 Box2 Name1 Name1 Name2 Name2 Name3 Name3
I defined the table name Box1 and Box2, now I would like to achieve something like this
When I type in cell A1 text will display me the whole table content in column B
Thank you for all help.