Likely cause:
What's in B5 isn't found in A2:A170 OR A2:A170 is not sorted.

"da" wrote in message
...
Whyn do I get NA error when I type the following formula.

=VLOOKUP(B5,SS!$A$2:$C$170,2)
SS is the worksheet
A2 has last name
C170 has personal ID #

Thanks