Formula Required

  • Please help


    I'm looking to add formulas to my spreadsheet that can index/match across multiple tabs, and return:


    1) Match

    2) Next cell beyond the match

    3) The previous cell that isn't empty



    Below is the Sheet I'm working on. The Info Tab needs to update who the Next Runner is, what time they start, who the second runner is, the time they start, and what time the current runner started.