Excel formula help

Regular Visitor



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.

1 Reply

@Temi_1 , what is the panel in your terms and how do you name them technically?