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
=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 so much! This was way above my skill level. Any advice on how to hone my skills with this? Thanks again!!
You are welcome! Here is information on INDEX and MATCH. This page also has information on many other Excel functions.
Two-way lookup with INDEX and MATCH - Excel formula | Exceljet
