Forum Discussion
Solved
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...
=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
- Thank you for the reply!
