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
Bookmarks