Issue with returning proper row number using =Small Function

Hello,

I've hit a roadblock. I'm trying to use the =Small function to retrieve a number of results to populate a column. However there are multiple criteria. I tried following the MS office tutorial here: http://office.microsoft.com/en-us/ex...001226038.aspx

It helped somewhat, but I'm having a hard time finding out why it isn't working.

Here is my single variable formula: =SMALL(IF(Indoor_Make=$C&86,ROW(Indoor_Make)),ROW(1:1)) +shift +enter Where "Indoor_Make" is an array that is 1 column on a separate sheet.
The above formula is pasted down a blank column until I get an error.

Here is my double variable formula: =SMALL(IF(COUNTIFS($C$86,Indoor_Make,$D$86,Indoor_Zone),ROW(Indoor_Make)),ROW(1:1)) +shift +enter Where "Indoor_Make" and "Indoor_Zone" are both arrays that are columns on another sheet.
The above formula is pasted down a blank column until I get an error

Both of the above work in returning the correct row numbers for the criteria when compared with the data on the separate sheet. The double variable formula works, and returns the row numbers that match both criteria.

Here's where I run into a problem. I try using the tutorial's formula for displaying the data in the matching rows
Here is my formula: =INDEX('Indoor Unit Details'!$A$1:$R$500,SMALL(IF(COUNTIFS(Indoor_Make,Dashboard!$C$86,Indoor_Zone,Dashboard!$D$86),ROW(Indoor_Make)),ROW(1:1)),3) +shift +enter Where 'Indoor Unit Details'!$A$1:$R$500 is the table I'm referencing on the separate sheet and I want to return the results in Column 3 that match the rows that fit both criteria.

The problem is, it isn't working. It displays what is in column 3, but it ignores the criteria and just displays everything. What am I doing wrong?

Many Thanks and Best Regards,

Sard