Excel MATCH Function

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to write a query which will allow me to capture multiple events 4
How to verify headers 2
Can't get array formula to work in MATCH function 5
"IN Operator" using Match function.... 2
Lookup Function 1
Value errors in Match function 5
SUMDIVISION formula function - does it exist? 6
Comparing then populating 1

Top