Nested if statement to look in between multiple date columns to see if tag is applicable based on 1 date

[lizfrinko]

Hi everyone,
I need help writing a nested if statement to solve for the "desired result" column. I need to look in between each of these dates and determine which was most recent to the "comparison date", and display the "desired result" tag.

The combinations on this are driving me crazy and I think there has to be a simple approach here. Do I write the if statement to look between all the date columns aside from the comparison date? Any help is appreciated, thank you.

DateA	DateATag	DateB	DateBTag	DateC	DateCTag	DateD	DateDTag	Comparison Date	Desired Result
11/14/2017	AAA	3/27/2019	BBB	4/22/2019	CCC	-	-	4/21/2019	CCC
2/1/2018	AAA	-	-	-	-	-	-	4/29/2019	AAA
3/1/2017	AAA	4/1/2017	BBB	5/1/2018	CCC	1/5/2015	DDD	4/29/2019	CCC
11/1/2018	AAA	12/15/2018	BBB	1/5/2019	CCC	2/6/2019	DDD	4/29/2019	DDD

<tbody>
</tbody>

 

[CyrusTheVirus]

Welcome to the forums. Maybe try the below formula in Cell K2. Then just copy down the formula.

=INDEX(A2:H2,,MATCH(MAX(A2:H2),A2:H2,0)+1)