This formula works, but of course it only gives the first instance:
=INDEX($A$2:$A$100,MATCH(1,($L$2:$L$100<"")*($L$2 :$L$100<"Resolved"),0)).

So I tried created this formula as an array:
=INDEX($A$2:$A$100, SMALL(AND(IF(($L$2:$L$100<""),(
$L$2:$L$100<"Resolved")), ROW($A$2:$A$100)),ROW(1:1)))
I receive #N/A. Any suggestions on how to fix the formula? Column A has the
information I'd like returned if the conditions are met in column L. Column L
is the result of a VLOOKUP you all helped me with previously. Eventually I'll
evolve the formula to do the look up from another worksheet. Is this enough
information or do you need more?

Thank in advance.