| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find the second match using the match function | Excel Worksheet Functions | |||
| how can we get unique values in match function for same match key. | Excel Worksheet Functions | |||
| index match array function-returning only first match, need last. | Excel Worksheet Functions | |||
| Match as well as does not match array function | Excel Discussion (Misc queries) | |||
| Excel Function to Match Power Trendline in Chart? | Excel Worksheet Functions | |||
![Sal[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
