VLOOKUP problem with N/A#

from what I can see, some of the lookup values dont exist in your lookup range.

Your data in the JSRMP sheet in col A which do not contain alpha characters are text, while in the other sheet they are numbers
This gives the error.
To correct easily type 0 in an empty cell - select the cell and copy
select all column A in JSRMP right-click - Paste special and in "Operation " section check "add" - then click OK

AuthurB you hit the nail on the head, thank you very much. But would you tell me please why this worked? I've never used that technique before. Also is there a way to get the N/A# to go blank?

To have the N/A# show blank you need to use an IF statement

=if(isna(VLOOKUP(A2,JSRMP!$A$2:$C$213,2,FALSE)),"",VLOOKUP(A2,JSRMP!$A$2:$C$213,2,FALSE))

Also, a common cause for this error is that one of the values is a number, and the other is text. If the lookup table contains numbers, and the value to look up is text, try this

=VLOOKUP(--A2,JSRMP!$A$2:$C$213,2,FALSE)

If the lookup table contains text, and the value to look up is numeric, try

=VLOOKUP((A2&""),JSRMP!$A$2:$C$213,2,FALSE)

If you don't know you could always try.
=if(isna(VLOOKUP(--A2,JSRMP!$A$2:$C$213,2,FALSE)),VLOOKUP((A2&""),JSRMP!$A$2:$C$213,2,FALSE),VLOOKUP(--A2,JSRMP!$A$2:$C$213,2,FALSE))

Glad to help
erock's solution will be the easiest if you import new values without knowing if they are nrs or text

Cheers