Recall a whole table based on a selected cell value

panga83

New Member
Joined
Jul 23, 2019
Messages
2
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

Well-known Member
Joined
Mar 31, 2015
Messages
2,091
Office Version
365
Platform
Windows
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

New Member
Joined
Jul 23, 2019
Messages
2
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?
 

Forum statistics

Threads
1,085,842
Messages
5,386,292
Members
401,992
Latest member
CleverHopper

Some videos you may like

This Week's Hot Topics

Top