Looking for help – my mistake must be something simple, but I cant figure out why my formula results are wrong, and need someone to run their eye over it please
I have created a summary sheet to show user grades from various courses completed.
Formula on CA column is =INDEX('HS 2020 Course'!$AE$6:$AE$10,MATCH($E6,'HS 2020 Course'!$C$6:$C$10))
The grades are on the separate sheet in same excel document. This one called "HS 2020 Course" I am using email address to match my data as the names are not always an reliable match.
Thanks!!
I have created a summary sheet to show user grades from various courses completed.
Formula on CA column is =INDEX('HS 2020 Course'!$AE$6:$AE$10,MATCH($E6,'HS 2020 Course'!$C$6:$C$10))
The grades are on the separate sheet in same excel document. This one called "HS 2020 Course" I am using email address to match my data as the names are not always an reliable match.
Thanks!!