• referencing a moving target

    • This topic has 1 reply, 2 voices, and was last updated 24 years ago.
    Author
    Topic
    #356256

    Excel 97 SR-2: I have a spreadsheet that tracks an employees attendance. One worksheet per employee, customized to that employees anniversary year. Sample attached.

    I am looking for a way to find their current balance of vacation hours. The value I am looking for will be in column

    Viewing 0 reply threads
    Author
    Replies
    • #526947

      assuming every date starts on Sunday, and the date you’re trying to match is in a cell named ‘MatchDate’, the following formula may yield your desired results (or at least get you started towards an answer):

      =IF(ISNA(MATCH(MatchDate,Sheet1!$C:$C,0)),”prior to start”,INDEX(Sheet1!$L:$L,MATCH(MatchDate,Sheet1!$C:$C,0)))

      HTH

      Mark

    Viewing 0 reply threads
    Reply To: referencing a moving target

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: