INDEX/MATCH formula - problem handling a duplicate field

jgold20

Board Regular
Joined
Feb 4, 2018
Messages
130
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
 

Some videos you may like

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

CyrusTheVirus

Well-known Member
Joined
Jan 28, 2015
Messages
736
Office Version
  1. 365
Platform
  1. Windows
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,960
Messages
5,525,914
Members
409,671
Latest member
nasseralateek

This Week's Hot Topics

Top