Excel showing n/a for no reason

[Bryony309]

Hello,

I cannot figure out why this VLOOKUP will not pull through the student name.
Please can someone point out the obvious mistake.
Sheet 1 pulling through student ID from cell c2 and paste into D2. Looking up from sheet 2.

Thank you.

[MrShorty]

The text string "31679" is not equal to the number 31679. Make sure that your ID#'s are always numbers or always text strings (note that the result of the RIGHT() function is text).

Since I tend to prefer keeping numbers as numbers, I would probably nest the RIGHT() function inside of a VALUE() function. =VALUE(RIGHT(text,num_char)).