Only Looking up a Value based on Criteria

[CarlSarlsburg]

I am struggling with excel to look up values based on a certain criteria. I have figured out column D, where I am looking to see if there is another circuit with the same name that had an outage in less than or equal to two second later. What I am trying in column E is to go find the the time of that outage that was on the same circuit in less than or equal to two seconds later. In my sheet with real data I am using OFFSETS because I know that in my real data I figured out the maximum number of rows down from where I am checking that an outage could occur with that criteria. I would like the formula in column E to use offsets or a range that is not the entire spreadsheet because I know I only need to look so far. Column E has my expected values but I am not able to figure out how to write an excel formula that calculates what I am trying to achieve. See attached excel test sheet.

Thanks for the help!

[FDibbins]

This (probably) a more efficient way to determine Y/N in D....
=IF(B3="","no",IFERROR(IF(INDEX(C3:$C$12,MATCH(B2,B3:$B$12,0))-C2<=2,"yes","no"),"no"))
If you need to go beyond row 12, adjust the $12 parts

For col E, try this...
=IF(OR(B3="",D2="no"),"NA",IFERROR(INDEX(C3:$C$12,MATCH(B2,B3:$B$12,0)),"NA"))