Excel MATCH Function

  • Thread starter Thread starter Sal
  • Start date Start date
S

Sal

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
 
Back
Top