Searching a Table for 2 search terms and returning all answers

In Lookup, A4, copied across and down:

=IFERROR(INDEX('T24 Controls'!A:A,AGGREGATE(15,6,ROW(T24_Controls[[Qty.]:[Qty.]])/((T24_Controls[[Type]:[Type]]=$E$2)+(T24_Controls[[Series]:[Series]]=$C$2)),ROWS(A$4:A4))),"")

Also... amend the formula in D4 to read (at the end...), to get rid of irritating zeros...

.......[Series]]=$C$2)),ROWS(A$4:A4)))&"","")

see sheet.

Your location is ambiguous... there are several San Marcos's.... if you're in one of the Spanish speaking ones, you may need to use ; instead of ,

Please amend your location, in your User CP, to remove ambiguity.

You're welcome.

---

It would be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.

Finally, if that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

You changed my formula. So, of course it doesnt work.

=IFERROR(INDEX('T24 Controls'!A:A,.....

you decided to change it to:

IFERROR(INDEX(T24_Controls[Qty.],....

change it back the way I set it up.

I am beginning to think I have misunderstood your requirement. In your first post, I understood that you were checking for X or Y...

However, version will make no difference. It is NOT an array formula. I did not tell you to array enter it, but that will not make any difference, either,

I have extended it out by one column. You will see that it is returning values that are EITHER Pack OR Lutron. Did you want values thta are BOTH Pack and Lutron??

If so, change the + to a * :

=IFERROR(INDEX('T24 Controls'!A:A,AGGREGATE(15,6,ROW(T24_Controls[[Qty.]:[Qty.]])/((T24_Controls[[Type]:[Type]]=$AB$2)*(T24_Controls[[Series]:[Series]]=$Z$2)),ROWS(X$4:X4))),"")

It's never dumb if you haven't done it before... just different!!