| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Match / Index multiple criteria return multiple results
Help I'm stuck!
Sample Data Sheet1 A B C Stock# Sales Person Type 90012 Bill New 91048 Sam Used 90456 Bill Used 91234 Frank New 91114 Bill New 91486 Bill New Sheet 2 A B C Bill New (Drop down boxes to select search criteria) Results I'm wanting if "BILL" in b1 and "New" in C1: 90012 Bill New 91114 Bill New 91486 Bill New Results I'm wanting if "BILL" in b1 and "Used" in C1: 90456 Bill Used Results I'm wanting if "BILL" in b1 and "" in C1: 90012 Bill New 90456 Bill Used 91114 Bill New 91486 Bill New Stock numbers are unique if that helps |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Index & Match functions - multiple criteria and multiple results | Excel Worksheet Functions | |||
| Obtaining Multiple Results Using Index/Match Functions | Excel Worksheet Functions | |||
| Obtaining Multiple Results Using Index/Match Functions | Excel Worksheet Functions | |||
| Obtaining Multiple Results Using Index/Match Functions | Excel Worksheet Functions | |||
| Index/Match Multiple Criteria | Excel Discussion (Misc queries) | |||
Threaded Mode
