Index Match - wrong results

[Fi_83]

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!!

 

[Fluff]

try
=INDEX('HS 2020 Course'!$AE$6:$AE$10,MATCH($E6,'HS 2020 Course'!$C$6:$C$10,0))

Otherwise you are looking for an approximate match.

 

[Fi_83]

This worked!! thank you

 

[Peter_SSs]

Another option if you have XLOOKUP (it has exact match as its default)

=XLOOKUP(E6,'HS 2020 Course'!$C$6:$C$10,'HS 2020 Course'!$AE$6:$AE$10)

 

[Fluff]

This worked!! thank you

You're welcome & thanks for the feedback.