Subtotal with index and match function

Hello forum,
Im trying to get the matching values of a filtered set using subtotal. I can't get the index - match to work with subtotal it does not use the filtered set.

I have put an example where I want to get the name from the value of subtotal, if there are more than one that has the filtered value I am happy if it picks the first name in the list.
Is there a way to apply conditional formatting for the resulting name as well so it will be easier to find in the list?

The wanted result is written manually in E column with red text.


Thanks

Administrative note
Hi
your profile indicates XL2003 . Is this still the case? If not, please upgrade your profile accordingly. Thanks

Try the following:
1. (2011 Mac version) For E1 and dragged down to E2: =INDEX(B$8:B$41,AGGREGATE(15,6,(ROW(A$8:A$41)-ROW(A$7))/(E$8:H$41=C1),1))
(2007 PC version) For E1 and dragged down to E2*: =INDEX(B$8:B$41,SMALL(IF(E$8:H$41=C1,ROW(B$8:B$41)-ROW(B$7)),1))
*Denotes an array entered formula which is confirmed by simultaneously pressing the Ctrl, Shift and Enter keys before copying.
2. For E3 and dragged down to E4: =INDEX(B$8:B$41,MATCH(C3,M$8:M$41,0))
Let us know if you have any questions.