INDEX MATCH with multiple criteria NOT working for me in any circumstance

**tylerm259** · 11-30-2023, 11:50 AM

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.PNG p2.PNG

**AliGW** · 11-30-2023, 11:50 AM

Welcome to the forum.

There are instructions at the top of the page explaining how to attach your sample workbook (yellow banner: HOW TO ATTACH YOUR SAMPLE WORKBOOK). Screenshots are of little practical use as we cannot manipulate them.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.