Hey All- I believe I am looking for a simple index match function based on two criteria, but I must be missing something basic (typically rely on vlookups). I want to return the ticket number for a specific NPI that the Patient Services team is working on. The intent is to combine this weekly report into a master file, with other weekly reports received. Unfortunately, I keep receiving an error message. Any help would be greatly appreciated. ('New Master'!A4=NPI in the master file).
=INDEX('New IS- Open'!B3:B7,MATCH('New Master'!A4,'New IS- Open'!A3:A7,0),MATCH({"Patient Services"},'New IS- Open'!E3:E7,0))
<tbody>
</tbody>
=INDEX('New IS- Open'!B3:B7,MATCH('New Master'!A4,'New IS- Open'!A3:A7,0),MATCH({"Patient Services"},'New IS- Open'!E3:E7,0))
A | B | C | D | E |
NPI | Ticket # | State | Date Opened | Assignment Group |
12345 | SCTASK0300001 | In Progress | 10/12/2018 | Epic Scheduling Cadence |
12345 | SCTASK0300002 | In Progress | 10/11/2018 | Epic Ambulatory |
12345 | SCTASK0300003 | Closed | 10/11/2018 | Epic SER |
12345 | SCTASK0300004 | In Progress | 10/11/2018 | Patient Services |
67890 | SCTASK0300005 | Closed | 11/10/2018 | Epic Scheduling Cadence |
67890 | SCTASK0300006 | Closed | 11/10/2018 | Epic Ambulatory |
67890 | SCTASK0300007 | In Progress | 11/9/2018 | Patient Services |
<tbody>
</tbody>