I don't know why the ...IF(OR(... was throwing a #NAME? error however it isn't now. I got rid of that last IFERROR as it appears to be unnecessary. This seems to be working:Let me know if you have any questions.Formula:![]()
=IF(J5=1,"",IFERROR(INDEX(C:C,MATCH(J5,A:A,0)),IF(OR(IFERROR(K4=INDEX(B:B,MATCH(J5+2,A:A,0)),FALSE),ISERROR(MATCH(J5+2,A:A,0))),"",INDEX(B:B,MATCH(J5+2,A:A,0)))))
Bookmarks