Excel MATCH Function
 

I'm not sure how to go about this, but I have an array with some data
and Want all the numbers associated with two criteria. I've tried
double matches, Index, combo of both. I have two combo boxes, One for
State, one for MAnager. BAsed on which state and manager is picked, I
want all the location numbers associated with that choice. Any
suggestions? Sal-

Col A Col B Col C
NJ TODD 12118
NJ TODD 12119
NJ COLIN 12120
NJ COLIN 12121
NJ COLIN 12122
NJ COLIN 12123
NJ COLIN 12124





Criteria1 Criteria2 Desired Results
NJ TODD 12118
12119




Criteria1 Criteria2 Desired Results
NJ COLIN 12120
12121
12122
12123
12124

Excel MATCH Function
 

Use AutoFilter. You can set criteria on each column.
--
Gary''s Student - gsnu200908


"Sal" wrote:

I'm not sure how to go about this, but I have an array with some data
and Want all the numbers associated with two criteria. I've tried
double matches, Index, combo of both. I have two combo boxes, One for
State, one for MAnager. BAsed on which state and manager is picked, I
want all the location numbers associated with that choice. Any
suggestions? Sal-

Col A Col B Col C
NJ TODD 12118
NJ TODD 12119
NJ COLIN 12120
NJ COLIN 12121
NJ COLIN 12122
NJ COLIN 12123
NJ COLIN 12124





Criteria1 Criteria2 Desired Results
NJ TODD 12118
12119




Criteria1 Criteria2 Desired Results
NJ COLIN 12120
12121
12122
12123
12124
.