Recall a whole table based on a selected cell value

[panga83]

Hi,

I have a number of tables (in a single sheet). Each table has some properties (temperature, presssure) pertaining to a particular pipe material group.

What I want is that when i select one of the material groups (in another sheet), it displays all the values related to that table underneath.

 

[DRSteele]

Welcome to the forum.

I have Excel365 Insider, so I hope this also works in old software.

Put a DataValidation list somewhere; in my test case, it's M9. It contains the List of the names of the ExcelTables. In my test case one of them is Table5 and the other Table6. Put this formula near M9: [FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]=INDIRECT(M9&"[#All]")[/FONT]

 

[panga83]

Welcome to the forum.

I have Excel365 Insider, so I hope this also works in old software.

Put a DataValidation list somewhere; in my test case, it's M9. It contains the List of the names of the ExcelTables. In my test case one of them is Table5 and the other Table6. Put this formula near M9: =INDIRECT(M9&"[#All]")

Thank you for your prompt response. I am using Windows 10, Excel 2016.

As any file sharing websites are blocked in my office, is there any other way I can share my file?

 

[DRSteele]

You can upload sample data using the HTML Maker. https://www.mrexcel.com/forum/excel-...ins-links.html