Creating Summary sheet - VLOOKUPS/INDEX Returning Multiple Values

[kelster]

Hi,

I hope someone can help me with the best solution for this.

I have a tab that contains thousands of different records, both rows and columns. I want to create a summary sheet that only gives me certain columns and based on 2 lookup values. The user would change these 2 values to suit and the report would change dynamically based on those values.

My Summary sheet will have 2 Criteria on it where the user selects 2 values they want to report on (I will have these in a drop down box) - these 2 values correspond to columns I and N on my main data sheet.

When the users selects these 2 values I want my summary sheet to display all the records that meet that criteria, returning values from columns e, d, r, v, w, o, z, AD, AG, AW, AW, AY in columns across my summary sheet.

I initially thought on my summary sheet I would insert some sort of INDEX Array formula to return the first value then do lookups on that value but the first value may not be unique. I essentially want to have a filtered smaller version of the main sheet. Does that make sense?

Can this be done? Would it be easier through a Macro/VBA?

thanks for any help