Help Returning a Cell Range Address using Mapping Criteria

[mysites]

I need help with a formula that returns a range of cells starting with the first cell that matches a set of criteria to the last cell that matches that criteria. My list is sorted so that cells are grouped by criteria.

	A	B	C
1	Member Name	Criteria1	Criteria2
2	Member1	Group1	Map1
3	Member2	Group1	Map1
4	Member3	Group1	Map1
5	Member4	Group1	Map2
6	Member5	Group1	Map2
7	Member6	Group2	Map1
8	Member7	Group2	Map2

<tbody>
</tbody>

The formula must take the two criteria as input and return a cell range that can be used in another formula. So if I submitted the values "Group1" and "Map1", the formula would return the value A2:A4. Any help would be appreciated. Thanks!

 

[steve the fish]

Assuming it is sorted this returns what you ask for:

=ADDRESS(MATCH(1,INDEX(($B$1:$B$8="Group1")*($C$1:$C$8="Map1"),0),0)+ROW($B$1)-1,1,4)&":"&ADDRESS(LOOKUP(2,1/(($B$1:$B$8="Group1")*($C$1:$C$8="Map1")),ROW($B$1:$B$8)),1,4)