You might have to put VALUE( ) around your RIGHT formula to convert it
to a number, and as Kevin has pointed out the widths of your ranges are
inconsistent with the column number you are trying to return data from.

Hope this helps.

Pete