INDEX/MATCH formula - problem handling a duplicate field

[jgold20]

I have a INDEX/MATCH formula, whenever it encounters a duplicate, it is being ignored. Otherwise it works fine

=IFERROR(IF(COUNTIF($J$3:J3,J3)=1,MATCH(J3,INDEX(Input_Events,,5),0),MATCH(J3,INDEX(INDIRECT(ADDRESS(ROW(Input_Events)+K2,6,1,1)):data!$J$102,,2),0)+K2),"")

Thanks

 

[CyrusTheVirus]

I know they might not be all that pretty, but helper columns are SUPER helpful. Perhaps you could be assisted by adding a helper column (like a COUNTIF to isolate first/second/third etc. duplicates) to your data set, and then reference that column.

 

[jgold20]

There already is a COUNTIF. It is the first statement.