Index/Match Formula Formula with multiple criteria

[Sandman1985]

Hi All,

Hope you're well. I'm struggling with a formula and I can't figure out where I am going wrong.
I basically have a large data table with dates in row 2 and classifications in column E.
I have used an index/match formula to extract data from the bigger table (1 year) into a weekly summary (which has a dynamic week ending date cell). It is displaying the classification rather than the value that corresponds with the classification and date:
=IFERROR(INDEX('Running Sheet Data'!$E$3:$E$8,SMALL(IF(INDEX('Running Sheet Data'!$E$3:$DN$8,0,MATCH(Sheet6!B$2,'Running Sheet Data'!$F$2:$DN$2,0))=$A3,MATCH(ROW('Running Sheet Data'!$E$3:$E$8),ROW('Running Sheet Data'!$E$3:$E$8)),""),ROWS('Running Sheet Data'!$E$1:$E1))),"")
I think I have messed up the order.
My formula references the following:
'Running Sheet Data'!$E$3:$E$8 - The classification in the data table
'Running Sheet Data'!$E$3:$DN$8 - The data set
Sheet6!B$2 - the date of the first day in the weekly summary
'Running Sheet Data'!$F$2:$DN$2 - the dates across the top of the data set
$A3 - the classification in the summary

Any assistance would be much appreciated.

Regards,

Sandman

 

[Fluff]

Can you post a sample of your data along with expected results.

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.