Require Help with Lookup Function

[Randy11]

Have a workbook with a recap page showing monthly results. Am setting up a New page (Month Result Page) showing a months results based on a date drop down list. See Samples:
Recap Page
Monthly Error Detail Jan-10 Feb-10 etc..
Error Category Volume Rank Volume Rank
Error Type 1 1 3 0 4
Error Type 2 0 4 0 4
Error Type 3 0 4 5 1
Error Type 4 2 2 1 3
Error Type 5 0 4 0 4
Error Type 6 0 4 0 4
Error Type 7 0 4 2 2
Error Type 8 8 1 0 4
Error Type 9 0 4 0 4
Error Type 10 0 4 0 4

Month Result Page
(what I need)(would like to lookup top 3 errors for the month choosen by Validation List drop down)(basically if month equals "Jan-10", lookup in Rank column for the appropriate month "1", return "Error Type"

Top 3 Errors for Month
Choose Month by Drop Down
Jan-10 Error Ranking
Error Type 8 1
Error Type 4 2
Error Type 1 3

Appreciate any help that can be provided.

 

[SkipVought]

Hi,

Have a workbook with a recap page showing monthly results.

Where is the source data for the recap page?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[Randy11]

On Monthly input worksheets in same workbook named Jan10, Feb10 etc

 

[SkipVought]

Excel is soooo easy to use and it soooo easy to make big mistakes.

One of these mistakes is chopping similar data up into different places, like worksheets. This makes your task many times greater than it would take, had you structured ALL your data in ONE TABLE, with a column for the date reflecting the accounting month.

In order to accomplish that, copy the data from each month's accounting into a single sheet and fill down with that accounting month's first of the month date in the adjacent column to the right. Label that heading appropriately.

Once you have all your data in one sheet with one row of heading and no empty rows within the data, you can use Data > Pivot table and Pivot Chart and summarize your data. If you know what you're doing, it can take less than 30 seconds to display the results you described.


Skip,

_{Just traded in my old subtlety...
for a NUANCE!}