Enzo_Matrix
Board Regular
- Joined
- Jan 9, 2018
- Messages
- 113
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?
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?
Code:
=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!")