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?

Related Conversations
Creating A Sublist
zjohnson in Excel on
5 Replies
Excel Forumla to exclude empty cells.
ulken2019 in Excel on
6 Replies
Need FORMULA help please!!
marislav in Excel on
4 Replies
Consolidating data from multiple worksheets
Machala Sentance in Excel on
3 Replies
Merge Cells with Different Data Types
CaffeineKing in Excel on
2 Replies
Need help with concatenate formula
Dave Cunningham in Excel on
2 Replies