V Look up for 2 sets of criteria

[Statz]

File attached.

My ultimate goal here is the ability to have a "timeline" of past dates based off the year & date I'm referencing. I have converted the actual date to just a day/month. I removed the year because that keeps me from doing what I want.

In the 2017 Final tab you'll see Cell A3 showing 2017 (that is the year). Cell E3 is the date (11/28). And column T has information that I want to populate into the "timeline" tab.

In the timeline tab I want B3 to populate column T because A3 says 2017 & B1 says 11/28.

This is just to get me started. What I'd like to do is always have the years going down in column A. But I always change the date in B1. This way I can always reference back to a previous day from different years. I call this a timeline similar to facebook timeline program where each day you see what you posted from prior years.

Thanks

[Fluff13]

How about
=INDEX('2017 Final'!T3:T5,MATCH(A3&"|"&B1,'2017 Final'!A3:A5&"|"&'2017 Final'!E3:E5,0))

...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.

[Statz]

Thank you!

Anyway to briefly explain in lamens terms what array does? I've used it before years ago but never understood it.

[Fluff13]

Glad to help & thanks for the feedback.

The formula is concatenating A3 & B1 on "Timeline" line sheet & then columns A & E on the "Final" sheet.
For more info on array formulae have a look here https://www.ablebits.com/office-addi...nctions-excel/