Populate data in a table based on dropdown criteria

Hi,

This is my first post to the forum. So far I've found the information here to be excellent. I've been trying to get a table to populate based on a couple of criteria. However, I've not come-up with the solution yet.

I have my dropdown selections in cells C2 & C3. The objective is to populate the table below the dropdown with data from the sheet named (very unimaginatively) 'Data'. Currently you see the selection AA-11 & Mar-14 in the Contract ID & Month cells. If I change this, the table below should auto-populate.

I've attempted using Vlookup, Index-Match. But it does not give me the desired result.

Also, the number of Products can change each month (although the file shows 4 for each month & each Account).

Thanks in advance.
Rags

How about:

Please Login or Register  to view this content.

Cheers,

Sorry. In your example workbook, you had the "table" features activated, so I assumed you were familiar with the named ranges it provided.

Here is the formula with normal range references:

Please Login or Register  to view this content.