View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
DA DA is offline
external usenet poster
 
Posts: 104
Default Vlookup table error

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