Jul 29 2022 09:53 AM
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
Jul 29 2022 10:06 AM
=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.
Jul 29 2022 10:10 AM
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 ) )
Jul 29 2022 10:12 AM
I'm bit late, the only difference with @OliverScheurich variant you don't need Ctrl+Shift+Enter on pre-DA Excel.
Jul 31 2022 02:12 AM