Index match multiple criteria

[kripper]

Been a while since I posted.....have had a lot of success with tips from the amazing people here.....but now I am stumped, can't seem to get this formula to pull the results I need, just get an #NA error.

I have a two part question if I may.....

{=INDEX('Q1'!$A:$A,MATCH(1,INDEX(('Q1'!$C:$C=$D3)*('Q1'!$BI:$BI>=AAA$35)*('Q1'!$BI:$BI<=$AAB$35),0,1),0))}

On the data sheet is a serial number, column c, is an employee number and column BI is a date value column identifying the date of the call, and I am trying to get the formula to reference the serial number between the two dates in question using the employee number as reference.

Then on the next column, I want to pull the next serial number for the same employee in the same date range.....using the second formula..

{=INDEX('Q1'!$A:$A,MATCH(1,INDEX(('Q1'!$C:$C=$D3)*('Q1'!$BI:$BI>=AAA$35)*('Q1'!$BI:$BI<=$AAB$35)*(COUNTIF($ZY$3:ZY3,'Q1'!$A$2:$A$9630),0,1),0))}

Hoping someone can help point out what I am missing.......

 

[kripper]

Sorry, I copied them, but didn't past as such, my apologies.

I have done the evaluation and formula checking, and it throws false, false, true when I make the necessary corrections.

 

[kripper]

My friend.....I found my error.......3 hours later, and some manual writing and trials.....but I did it.

{=INDEX('Q1'!$A:$A,MATCH($D3,IF('Q1'!$BI:$BI>=AMP$3,IF('Q1'!$BI:$BI<=AMQ$3,'Q1'!$C:$C,0)),0))}

{=INDEX('Q1'!$A:$A,MATCH($D3,IF('Q1'!$BI:$BI>=AMP$3,IF('Q1'!$BI:$BI<=AMQ$3,'Q1'!$C:$C,0)*(COUNTIF($ZY3:ZY3,'Q1'!$A:$A)=0),'Q1'!$C:$C),0))}

Thanks for the assistance.....greatly, greatly appreciated.....!