Forum Discussion
** HELP WITH INDEX & MATCH FORMULA **
Hi All, Im struggling with an index and match formula and require some assistance please 🙂 I need to create and index and match that will return the required email based on the MDF code as s...
=INDEX($B$3:$B$38, MATCH(LEFT(E12,2), $A$3:$A$38,0))This returns the intended result in my sheet.
=INDEX($B$3:$B$38, MATCH(TRUE, $A$3:$A$38=LEFT(E12,2),0))This formula works as well but it has to be entered with ctrl+shift+enter if one doesn't work with Office 365 or Excel 2021 because it's an arrayformula.