Home

Excel formula help

Highlighted
Regular Visitor

Hello,

 

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
Highlighted

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

Related Conversations
excel formula
loriam1225 in Excel on
1 Replies
Process the big data
yoepls in Excel on
0 Replies
Row height
yorkiebasie in Excel on
1 Replies
Load the Analysis ToolPak plugin in Excel
Daniel10 in Excel on
0 Replies
Cant understand why i cant apply formula
Kwaker in Excel on
10 Replies
Getting data from web
PeterG380 in Excel on
0 Replies