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
4 Replies
I'm bit late, the only difference with OliverScheurich variant you don't need Ctrl+Shift+Enter on pre-DA Excel.
That could be
with
=INDEX($J$7:$J$10, MATCH( 1, INDEX( ($H$7:$H$10=$M8)*($I$7:$I$10=N$7), 0), 0 ) )- Wow first time to put a Q in this community! You guys are amazing!
=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.
