Index Match with Multiple Criteria and Wildcards

[hchurch]

I am somewhat familiar with Index / Match formulas, and have used them with multiple criteria on a number of occasions. However, I need to use a wildcard in Match portion for some of the data that I am now working with.

Here is the formula that I am currently using:

Please Login or Register  to view this content.

I need to add a 3rd criteria to the match formula looking for a specific text (say "Test" which is entered into H1).

The closest I have gotten is the formula below, however, it doesn't account for the criteria "(B2=$L$1:$L$13)" from the above formula.

Please Login or Register  to view this content.

[bebo021999]

Hard to write a formula without a sample worksheet, but try:

=INDEX($N$1:$N$13,AGGREGATE(15,6,ROW($N$1:$N$13)/ISNUMBER(SEARCH($H$1,$N$1:$N$13))/($M$1:$M$13=A2)/($L$1:$L$13=B2),1))

[hchurch]

Thank you Bebo021999. That appears to solve the issue I was dealing with. I am not familiar with the Aggregate function so I plan on doing a little research to become so. I apologize for not posting a sample worksheet, but the worksheet I am using has proprietary data in it, and I didn't have a chance to create something similar late yesterday with "bogus" data.