Also try this modified version in X2. Array entered of course.
Formula:
=IFERROR(INDEX(Date,MATCH("Close*",
CHOOSE(MATCH(T2,{"Long","Short"},0),
IF(ROW(Long_Ticket)-MIN(ROW(Long_Ticket))+1>=MATCH(R2,Long_Ticket,0),Long_Action),
IF(ROW(Short_Ticket)-MIN(ROW(Short_Ticket))+1>=MATCH(R2,Short_Ticket,0),Short_Action)),0)),"")
It's simpler in concept. The
ROW(Long_Ticket)-MIN(ROW(Long_Ticket))+1 and
ROW(Short_Ticket)-MIN(ROW(Short_Ticket))+1 parts replace the calls to named formulas L_Ticket_Indx and S_Ticket_Indx
One of them may perform better/faster than the other. All you can do is try.
Bookmarks