Need help with a lookup

I am trying to figure out if there is a way to do a lookup that is a bit different than the normal lookups. The first image below shows initials on the top and dates on the left. I am trying to have...

excel

Formulas and Functions

OliverScheurich
Sep 08, 2023
BlizzCo
=IFERROR((INDEX('Sheet 2'!$L$3:$L$21,MATCH(1,('Sheet 1'!$C39='Sheet 2'!$F$3:$F$21)*(E$19='Sheet 2'!$B$3:$B$21),0))),"")
You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021. The formula is in cell E39 in sheet 1 and filled across range E39:G54.

Sheet 1

Sheet 2