Help with "You've entered too many arguments for this function" multiple INDEX(MATCH

[BeachRock]

Hi everyone,

Separately the two IFERROR(INDEX(MATCH functions below work but I need to combine them and I can't find the misplaced parenthesis.

Please Login or Register  to view this content.

[FDibbins]

for a start, there looks to be something wrong here, at the start...
......,IFERROR(INDEX(Lists!$N$1:$N$147,MATCH(AB15,Lists!$I$1:$I$147,0))="Discontinued Product","DP",......
looks like you didnt close the ) after the "DP" to finish the IFERROR? either that or you are missing an IF() to start that with?

[BeachRock]

Hi FDibbins,

Thanks for the reply. I removed the IFERRORs completely and was able to get the two working together but then it showed a "False" in the cell if the criteria variables don't match. I got around that by using the formula below.

Please Login or Register  to view this content.