Dynamic table creation using formula.

[Sandeep Sharma]

Hello,
I have 3 defferent size of table in excel of different sizes i.e (7RX5C, 8RX5C, 9RX5C) and i want to create a master dynamic table in excel using formula with drop-down name of three table ( tbl_1, tbl_2, tbl_3). so that after slecting the name of table in drop down the respective table get displayed in the master table. Plz help me .

Thank you.

 

[azumi]

Maybe better if you attach your sample file, and explain what the results

 

[Sandeep Sharma]

Maybe better if you attach your sample file, and explain what the results

 

[Syedali]

PFA

 

[XOR LX]

Hi.

In A14:

=IFERROR(INDEX(INDIRECT($C$13),ROWS($1:1),COLUMNS($A:A)),"")

Copy across and down until you start to get blanks for the results.

Regards