getting close, no longer getting FALSE.

Formula is working correctly for the "M", but not the "A" I should be getting "yes" with a value of 1, but am getting No

I really do appreciate your help.


Master_Service_Award.xlsm