#NA in VLookup

From: Carlos (anonymous_at_discussions.microsoft.com)
Date: 04/28/04 

Date: Tue, 27 Apr 2004 18:28:13 -0700

employee ID should be the FIRST column in your range
(ADROCK), i assume for what you wrote, that this field is
actually the second column (i.e, column B)... That might
be the problem... try re-defining the range (ADROCK)

>-----Original Message-----
>I have a data range named ( ADROCK) in a work*** (of
the same
>workbook) and it has a common field with a work*** that
I want to
>insert information in a column. In this case, the common
field
>contains employee ID numbers(Column B in the destination
work***) and
>I want to capture the job titles from the ADROCK range
and put it in my
>new column. I typed:
>
>=VLookup (B3, ADROCK, 4, False)
>
>but I can't get anything to happen but #NA. I've checked
and rechecked
>column numbers, etc. What's wrong?
>
>
>---
>Message posted from http://www.ExcelForum.com/
>
>.
>