My sheet looks like this:

Name1 Name1 Name2 Name3
Date1 Date2 Date3 Date1
DATA DATA DATA DATA
DATA DATA DATA DATA
DATA DATA DATA DATA

I have a "Project_Name", "Date", and "Data" rows.

I'm using INDEX and MATCH to lookup the Data. I understand how to do this if there was no "Date" row. But the Projects have multiple (re-evaluation) Dates, so I don't know how to make Excel check 2 different rows in the INDEX function.

(I'm trying to avoid appending the Project names, eg Atlanta1, Atlanta2.)

Thanks,
Mark