Hi,
Untested but perhaps
![]()
Cells(60000, 256).Value = "=IFERROR(INDEX($" & saddr & "$1:$" & laddr & "$" & data_LastRow & "," & j & ", MATCH(" & Position & ",$" & saddr & "$1:$" & laddr & "$1,0)+1),INDEX($" & saddr & "$1:$" & laddr & "$" & data_LastRow & "," & j & ", MATCH(" & Position & ",$" & saddr & "$1:$" & laddr & "$1,0)))""
Bookmarks