Jacob Skaria;391947 Wrote:
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
---------------
Jacob Skaria


"da" wrote:

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

Why do you need FALSE in the Vlookup if the column is sorted?


--
NBVC

Where there is a will there are many ways.
------------------------------------------------------------------------
NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=109441