Excel Index/Match i got stuck

New Contributor

Hi There,


Please advise i would like to get specific values for these but it returning error.  Basically it should show there complete or incomplete.  Thank you wizards!






4 Replies



You can try this formula for the data layout of the example. Enter the formula with ctrl+shift+enter if you don't work with Office365 or 2021.

index match.JPG


That could be



=INDEX($J$7:$J$10, MATCH( 1, INDEX( ($H$7:$H$10=$M8)*($I$7:$I$10=N$7), 0), 0 ) )


I'm bit late, the only difference with @Quadruple_Pawn variant you don't need Ctrl+Shift+Enter on pre-DA Excel.

Wow first time to put a Q in this community! You guys are amazing!