I have 5 columns of data and I’m using an INDEX/MATCH function to pull data from column 5 based on exact criteria matches from columns 1, 3 & 4. So basically the user chooses 3 different criteria (from dropdowns) and if all three match columns 1, 3 & 4 exactly then the result(s) comes from column 5.
Here’s the function I’m using…

{=IFERROR(INDEX(F5:F500,MATCH(1,(E5:E500=Production!B4)*(G5:G500=Production!B8)*(H5:H500=Production!B6),0)),"")}

Issue I had was depending on the criteria chosen there could be anywhere from 4 to 10 results so I used the following to pull the next results…

{=IFERROR(INDEX(F5:F500,MATCH(1,(E5:E500=Production!B4)*(G5:G500=Production!B8)*(H5:H500=Production!B6),0)+1),"")}

For each line I just added another number on the end of the function (ie. “+2” “+3”, and so on) to get the desired results. As I mentioned above some criteria will have less results and this is where my problem is… once I have all available results (for example 3 results) the next line (“+3”) should spit out an error because there are no more results that match the criteria exactly but instead the function just gives me the next result that matches the first two criteria but not the third. I apologize if this seems confusing, a little hard to explain which is probably why I couldn’t anything in the forums that helped.

Any advice would be very much appreciated. (Note: I removed the “$” from the above functions so they are easier to read)
Thanks!