Lookup and return data based on multiple criteria

[brchiz]

Hello, I have been able to sucessfully adapt the below formula into my spreadsheet, however, I would like to know if you can add any criteria to the index information that is returned.

To be more specific, I have a worksheet with several columns of data that I have this formula returning information from. There is one column on that spreadsheet with values of 0 and 1. I want this formula to only return values from rows with a 1 in column AB.

Here is my current formula:
{=IF(ROWS(F$6:F6)<=$J$4,INDEX('Oct 2011'!A:A,SMALL(IF('Oct 2011'!C:C=$B$4,ROW('Oct 2011'!C:C)-ROW($L$6)+1),ROWS(F$6:F6))),"")}

Here i what I have in J4:
{=SUM(('Oct 2011'!C:C='3 Month Drop'!B4)*('Oct 2011'!AB:AB=1))}

I want the formula in F6 to only return data from 'Oct 2011' if AB=1

Thanks
<!-- / message -->

 

[brchiz]

I found my answer in this thread:

http://www.mrexcel.com/forum/showthread.php?t=295493

Thanks for the help.