Multiple Vlookup - must be an easier formula?

[oldshape]

Hi all, the attached file contains a monster of a formula which is hard to edit....and will be even harder to edit by the person I hand over my work to.
The Green areas contain the formula.
There must be a way of using the Braces {} but I have tried every which way---failed.

Here is the formula, but there are more notes in the file.
No macro's allowed (Client rules).

=IFERROR(IF(OR(VLOOKUP(M10,$C$10:$H$35,2,0)="rr2",VLOOKUP(M10,$C$10:$H$35,3,0)="rr2",VLOOKUP(M10,$C$10:$H$35,3,0)="rr2",VLOOKUP(M10,$C$10:$H$35,4,0)="rr2",VLOOKUP(M10,$C$10:$H$35,5,0)="rr2",VLOOKUP(M10,$C$10:$H$35,6,0)="rr2"),"yes","No"),"Non")