Multiple row lookup for INDEX / MATCH?

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

Hi.
Can provide a sample file with some data?

Sample file attached.

2003 version attached.

Hello
I think that that is what you want

So anything just reply

kindm

Thanks a lot. SUMIFS works great!