concatenate and lookup last value

[smgomez]

I have concatenated two rows in first worksheet and found the first value in the second worksheet

worksheet1

Fiscal Year	Period
2020A	12

=VLOOKUP(CONCATENATE(E2," ",F2),'Time Periods'!A$2:H$215,2,FALSE) this formula gets me to my first Period From value of 8/29/2020 which is great and now in a separate cell I need to get to my last Period To value of 10/2/2020

Time Periods

Yr/Period	Period From	Period To
2020A 12	8/29/2020	9/4/2020
2020A 12	9/5/2020	9/11/2020
2020A 12	9/12/2020	9/18/2020
2020A 12	9/19/2020	9/25/2020
2020A 12	9/26/2020	10/2/2020

Thanks for your help

 

[Misca]

By far the easiest way to find the last date is using the MAXIFS-function:
=MAXIFS(Period To Range, Yr/Period Range, E2&" "&F2)

This one returns the max date on the Period To Range where the conditions match.

You could also use similar MINIFS-function to find the earliest date from the Period From range.

 

[smgomez]

WOW, so much easier THANKS. I used both MAXIFS and MINIFS to get to the dates needed