Creating a Summary Page where information from another sheet can pop up when searched for

[LLeo]

Hello!

So I have been given a new task at work. I currently have a sheet comparing about 20 different companies income statements side by side in columns with about 30 rows each. I need to somehow create on a separate sheet, a summary page where I will have the income statement from our company constant and then have some sort of search function where I can type in the ticker symbol of each company and have it pop up somehow so I can just compare that company to our company on the summary page. I have tried lookup functions, filtering and can't figure it out. Please help me!!

[Craig K.]

Please upload a sample spreadsheet (with sensitive information scrubbed out) so we could see the format you're working with.

[LLeo]

Great thanks!

[Craig K.]

Here's my crack at it. Solution for LLeo.xlsx
I used INDEX-MATCH functions in E2:F27 along with a Data validation in Cell E1.

Let me know if you have any questions.

[LLeo]

This is exactly what I need thank you so much for your help!! I will try and recreate it and if I have questions will definitely ask if I have them!

[LLeo]

I was able to figure it out and it worked perfectly thanks again! SOLVED