Formula to Return Cell Addresses Based on Multiple Mapping Criteria

[mysites]

I need a formula that returns a number of cell addresses/ranges based on multiple mapping criteria.

I have the following mapping dataset whose length may vary from day to day:

	A	B	C
1	Member Name	Mapping 1	Mapping 2
2	Member1	Group1	Map1
3	Member2	Group2	Map1
4	Member3	Group1	Map1
5	Member4	Group2	Map1
6	Member5	Group1	Map1
7	Member6	Group2	Map2
8	Member7	Group1	Map2
9	Member8	Group2	Map2
10	Member9	Group1	Map2
11	Member10	Group2	Map2

<tbody>
</tbody>

The member names are not numeric or alphabetical, so I need a formula that returns a series of addresses/ranges that can be used as Criteria inside of a SUMIF/SUMPRODUCT formula that I'll include below for reference. If I were to feed the formula the values "Group1" and "Map2" I'd expect the output to return the addresses A8 and A10.

These values will be passed to a SUMPRODUCT formula like the following:
=SUMPRODUCT(--(ISNUMBER(MATCH(HeaderRow,A8;A10,0))),--(ISNUMBER(MATCH(HeaderColumn,SomeRange,0))),DataRange)

Thanks!


Also it should be noted that the length of the mapping file may be shorter or longer than the length of my "HeaderRow" to which I compare it.

 

[mysites]

I learned that the MATCH function can't take multiple addresses as input, so this wouldn't work. I've created a new thread with the new requirements of the formula. This thread can be deleted or closed.