Vlookup table error

  • Thread starter Thread starter da
  • Start date Start date
D

da

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
 
If the data in Column A is sorted use
=VLOOKUP(B5,SS!$A$2:$C$170,2,FALSE)

If this columns is not sorted then try
=INDEX(SS!$A$2:$C$170,MATCH(B5,SS!$A$2:$A$170,0),2)

If this post helps click Yes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Vlookup Help 5
HELP! Lookup 3
VLOOKUP...have 3pm deadline but making progress almost there! 6
removing #na from a sheet 7
Vlookups and formats 3
Odd VLookup behavior 2
VLookup 1
VLOOKUP TABLE ERROR 6

Back
Top