Excel Index/Match i got stuck

Copper 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!

 

Vandal_Hartz_0-1659113553020.png

 

Fernan

 

4 Replies

@Vandal_Hartz 

=INDEX($C$2:$C$5,MATCH(1,($A$2:$A$5=$E3)*($B$2:$B$5=F$2),0))

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

@Vandal_Hartz 

That could be

image.png

with

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

@Vandal_Hartz 

I'm bit late, the only difference with @OliverScheurich 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!