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.)