Iferror Index Match - Error

[Enzo_Matrix]

This is a similar post to my original request but I need some additional help with it and the original post has fizzled into the back pages of the message board. I do apologize. Original Post: https://www.mrexcel.com/forum/excel-questions/1051180-iferror-index-match-error.html

I created this formula so that I can use 2 separate columns in my index search, but I can't get it to work for 4 columns. The number of columns that is referencing the same index might increase as our inventory expands.

Is it possible to add to the below code to accommodate a 3rd and 4th match or is there a VBA option that can be used in it's place?
​

=IFERROR(INDEX(Data!$A$3:$A$31,IFERROR(MATCH($I5,Data!$I$3:$I$31,0),MATCH($I5,Data!$L$3:$L$18,0))),"Try Again!")

 

[crazydragon84]

you can do sum(iferror(Match(case 1),0),iferror(Match(case2),0),iferror(Match(case3),0),iferror(Match(case4),0) Can use array formula instead as well.

with vba, you can just do a .find on I5 value in the range you are looking for, but essentially you are doing the same thing.

 

[AhoyNC]

See reply in your original post.

https://www.mrexcel.com/forum/excel-questions/1051180-iferror-index-match-error.html