Matching on multiple variables, like SQL's IN Function

Is there a way to match on multiple values within the MATCH function? This is my current formula to determine (and later, pick) a passing grade in a class (A to D-), with DF2 the ID:

=IF(ISNUMBER(MATCH(1, (DF2='GRADES'!$B$2:$B$16056)*(('GRADES'!$K$2:$K$16056="A")+('GRADES'!$K$2:$K$16056="A-")+('GRADES'!$K$2:$K$16056="B+")+('GRADES'!$K$2:$K$16056="B")+('GRADES'!$K$2:$K$16056="B-")+('GRADES'!$K$2:$K$16056="C+")+('GRADES'!$K$2:$K$16056="C")+('GRADES'!$K$2:$K$16056="C-")+('GRADES'!$K$2:$K$16056="D+")+('GRADES'!$K$2:$K$16056="D")+('GRADES'!$K$2:$K$16056="D-")),0)), "Yes", "No")

I tried to shorten it this way but it did not work:

=IF(ISNUMBER(MATCH(1, (DF2='GRADES'!$B$2:$B$16056)*('GRADES'!$K$2:$K$16056 = {"A","A-","B+","B","B-","C+","C","C-","D+","D","D-"}),0)), "Yes", "No")

Is there any way to shorten this formula in this manner? The only thing I could think of is to give each letter a number value, with D- at 1 up to A at 11, with F as 0:
=IF(ISNUMBER(MATCH(1, (DF2='GRADES'!$B$2:$B$16056)*('GRADES'!$K$2:$K$16056 >0),0)), "Yes", "No")

Thank you.

Thank you, but I need to have a dummy variable both for if the ID has a passing grade and another if it is a B or better, both Yes/No. I cannot just return the grade because a person may have taken the class multiple times with different grades. I am interested in if he or she ever passed or ever got a B or better.

Just curious, so there is no way to shorten the MATCH formula that way?

Thank you again.

Originally Posted by CK76

May be...

Formula:

Please Login or Register  to view this content.

Confirmed as array (CTRL + SHIFT + ENTER)

Thank you. This is much more efficient!

Originally Posted by Bernie Deitrick

This will return the number of A and A- grades for the ID in DF2: if can easily be extended to count B+ B B- etc...

=SUMPRODUCT((GRADES!$B$2:$B$16000&GRADES!$K$2:$K$16000=DF2&"A")+(GRADES!$B$2:$B$16000&GRADES!$K$2:$K$16000=DF2&"A-"))

Thank you. Do you know why this would not work within the Match function?