TRIM leading character

Hello,
I have written the following INDEX formula:
=IFERROR(INDEX(Sheet2!$I$2:$I$13,MATCH(Sheet1!C2&Sheet1!C3,Sheet2!A2:A13&Sheet2!$B$2:$B$13,0)),"No match found")

This formula provides rating of either R5, R5-,R6, R6+, or "No match found". I'm trying to eliminate the leading "R" in the output so it will either provide 5,5-,6, or 6+. Any idea on how to accomplish this?

Try it like this (changes shown in red):

=IFERROR(SUBSTITUTE(INDEX(Sheet2!$I$2:$I$13,MATCH(Sheet1!C2&Sheet1!C3,Sheet2!A2:A13&Sheet2!$B$2:$B$13,0)),"R",""),"No match found")

You will need to use Ctrl-Shift-Enter to confirm the formula, rather than the usual |Enter|.

Hope this helps.

Pete

Both worked wonderfully...thanks!