Posts by Andante

    Re: MATCHing a date within a range of dates

    Quote from NBVC;777266

    Are you trying to return a count of matches?

    No, sorry for the confusion. I'd like to return exactly what MATCH returns, the location of the match in the list. In this case, it will return the location of a match anywhere within that range of dates.

    I have a list of names in column B, amounts in column C, and dates in column D. None of the columns has only unique entries.

    Then in column A, I concatenate them.

    I would like to MATCH name&amt&date in column A, HOWEVER.....the date can vary from 5 days before to 5 days after.

    So my question is: how can I update MATCH("DOG"&54&42385,$A$2:$A$100,0) so that it returns the location in A of an entry with DOG, 54, and a date ranging from 42380-42391?

    SUMPRODUCT? Array formula? Something else?


    (I'm using Excel 2003.)