=ISNUMBER(MATCH(RIGHT(F15,2)+0,$A$6:$E$10,0))+0

The formula above worked, I thought, but now for some reason I can't get
anything but zero. Here's a sample of sheet.

A B C D E F
50 45 48 49 55 752
60 65 58 59 66 0
70 75 68 69 77 1595
80 85 78 79 88 7355
90 95 98 89 99 7

Any help would be great Thank you!
Luke