Forum Discussion
Excel Index/Match i got stuck
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! Fernan
=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.