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.

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD="align: center"]A
[/TD]
[TD="align: center"]B
[/TD]
[TD="align: center"]C
[/TD]
[/TR]
[TR]
[TD="align: center"]1
[/TD]
[TD]Member Name
[/TD]
[TD]Criteria1
[/TD]
[TD]Criteria2
[/TD]
[/TR]
[TR]
[TD="align: center"]2
[/TD]
[TD]Member1
[/TD]
[TD]Group1
[/TD]
[TD]Map1
[/TD]
[/TR]
[TR]
[TD="align: center"]3
[/TD]
[TD]Member2
[/TD]
[TD]Group1
[/TD]
[TD]Map1
[/TD]
[/TR]
[TR]
[TD="align: center"]4
[/TD]
[TD]Member3
[/TD]
[TD]Group1
[/TD]
[TD]Map1
[/TD]
[/TR]
[TR]
[TD="align: center"]5
[/TD]
[TD]Member4
[/TD]
[TD]Group1
[/TD]
[TD]Map2
[/TD]
[/TR]
[TR]
[TD="align: center"]6
[/TD]
[TD]Member5
[/TD]
[TD]Group1
[/TD]
[TD]Map2
[/TD]
[/TR]
[TR]
[TD="align: center"]7
[/TD]
[TD]Member6
[/TD]
[TD]Group2
[/TD]
[TD]Map1
[/TD]
[/TR]
[TR]
[TD="align: center"]8
[/TD]
[TD]Member7
[/TD]
[TD]Group2
[/TD]
[TD]Map2
[/TD]
[/TR]
</tbody>[/TABLE]

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)