Hello,

I have spent all morning trying to get an INDEX MATCH combination to work with multiple criteria but the problem is the MATCH function is returning the wrong values no matter what method I try.

=MATCH(1, ('PS November 2023'!$T$3=Form1[[ICE Contact ID]:[ICE Contact ID]]) * ('PS November 2023'!V$6=Form1[[Reviewer]:[Reviewer]]), 0)

Here is the formula for just the match portion, it is outputting N/A but if I wrap the 'PS November 2023'!$T$3 and Form1[[ICE Contact ID]:[ICE Contact ID]] in INT() then it outputs 18 when the output should actually be 19. And if I change the V in V$6 to a U for a different manager name then it gives me N/A again when it really shouldn't be doing that in my opinion. I am so completely stumped on this one. Please help.

=IF(AND(MATCH('PS November 2023'!$T$3, Form1[[ICE Contact ID]:[ICE Contact ID]]), MATCH('PS November 2023'!V$6, Form1[[Reviewer]:[Reviewer]])), INDEX(Form1!$Y:$Y, MATCH(1, (INT('PS November 2023'!$T$3)=INT(Form1[[ICE Contact ID]:[ICE Contact ID]])) * ('PS November 2023'!V$6=Form1[[Reviewer]:[Reviewer]]), 0), 1), "ERR")

This is going to be the entire formula with the INDEX MATCH.

Some screenshots of my tables will be posted below. Not sure if the images are going to post correctly since this forum looks like it was made in the 90's and my images are inline as an [ATTACH], but here is to hoping!

p1.PNGp2.PNG