#NA in VLookup

  • Thread starter Thread starter Pittmas
  • Start date Start date
P

Pittmas

I have a data range named ( ADROCK) in a worksheet (of the sam
workbook) and it has a common field with a worksheet that I want t
insert information in a column. In this case, the common fiel
contains employee ID numbers(Column B in the destination worksheet) an
I want to capture the job titles from the ADROCK range and put it in m
new column. I typed:

=VLookup (B3, ADROCK, 4, False)

but I can't get anything to happen but #NA. I've checked and rechecke
column numbers, etc. What's wrong
 
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)
 
Pittmas, VLookup returns #NA for one of two reasons: either the lookup_value
(value in B3 in your ex) is smaller than the smallest value in the first
column of the table_array (ADROCK), or range_lookup = FALSE (as in your
formula) and lookup_value does not find an exact match. You might try
checking to see if either of these applies. Or you might try changing
range_lookup to TRUE (or leaving it out) and see what that produces.

DDM
DDM's Microsoft Office Tips and Tricks"
www.ddmcomputing.com
 
Back
Top