Looking for some help, think I need to use a multiple criteria Index & Match. I've done it before but can't get it to work this time. Below is some dummy data
<tbody>
</tbody>
So above I have 3 candidates on 1 req. I want to pull into a summary page the candidate name who has been offered.
I tried [FONT="]=INDEX(Report!D1:D4,MATCH[/FONT][FONT="](Report![/FONT][FONT="]A1&E1,[/FONT][FONT="]Report!A1:A4&Report!E1:E4,0[/FONT][FONT="])[/FONT]) but I'm getting 0 as a result. Any thoughts?
Something better than I&M (no vba please, I'm In HR).
TIA
A | B | C | D | E |
Req ID | Job Title | Region | Candidate Name | Start Date |
1234 | Jobby Job | NE | AC Slater | 1/2/2018 |
1234 | Jobby Job | SW | Zach Morris | |
1234 | Jobby Job | MW | Kelly Kapowski |
<tbody>
</tbody>
So above I have 3 candidates on 1 req. I want to pull into a summary page the candidate name who has been offered.
I tried [FONT="]=INDEX(Report!D1:D4,MATCH[/FONT][FONT="](Report![/FONT][FONT="]A1&E1,[/FONT][FONT="]Report!A1:A4&Report!E1:E4,0[/FONT][FONT="])[/FONT]) but I'm getting 0 as a result. Any thoughts?
Something better than I&M (no vba please, I'm In HR).
TIA