Forum Discussion
Vandal_Hartz
Jul 29, 2022Copper Contributor
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
SergeiBaklan
Jul 29, 2022Diamond Contributor
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 ) )- Vandal_HartzJul 31, 2022Copper ContributorWow first time to put a Q in this community! You guys are amazing!