I am trying to find solutions to creating a lookup formula for an excel workbook I am working on.
I have a workbook with multiple sheets of information. Each sheets contains group panels. e.g. SHEET 1 contains grouped panel of TITLE 1, TITLE 2 TITLE 3
These panels have information manually entered under them. I am trying to create a summary page at the start to lookup information from any panel I
enter on the summary page. e.g. In the summary page, if I type TITLE 1, I want to see specific information about TITLE 1 in the summary page.
I have attached a pic which might give you comprehensive idea of what I am trying to do.
@Temi_1 , what is the panel in your terms and how do you name them technically?