I feel pretty comfortable with INDEX MATCH, but I came across a problem I'd like to use it on where I'm not quite sure it works. I have two sheets: the first smaller sheet has a small subset of names that are on the other sheet, and has a set of dates associated with each name. The other larger sheet has a different set of dates associated with each name. What I would like to be able to do is INDEX the dates on the larger sheet and MATCH names only IF this date is greater than the date on the smaller sheet and less than the end of the month associated with that date. Rather than return the MATCH value I would like to return, say, a 1 if the criteria is met. Is this something that can be pretty easily done with INDEX MATCH or is there another set of functions I should be looking for? How would you go about this?