works fine for me. Are you sure that some of your numbers aren't text cells?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"navneetjn" wrote
in message ...

Hi,

I am new to Vlookup and tried using it in the following format

Sheet1 is named "header" Sheet2 is named "detail"
The sheet "header" has 8 columns, 1200 rows (all unique), and detail
has 6 columns and 29000 rows (with duplicates).
The records in sheet "header" A2:A1200 are unique
e.g.
169255
169226
169247
169248
169249
The records in sheet "detail" A2:A29497 may be duplicate
e.g.
169255
169255
169247
169247
169247
169248
169248
169248
169248
169249

Data in each sheet starts in Row 2, with row 1 being the headers for
the data.

I used the following formula in the "header" sheet at cell location I2
=VLOOKUP(A2,DETAIL!$A$2:$F$29497,5,FALSE)
and pulled this formula across 1200 records in sheet "header" to show
the data corresponding to A2 in the range $A$1:$F29497 for the 5th
column.

I get a N/A as the result . Please tell me what I am doing wrong here?
Is there any other way to do it. I arranged the data in ascending order
on both worksheets, but it still shows N/A.

Thanks in advance
Navneet


--
navneetjn
------------------------------------------------------------------------
navneetjn's Profile:
http://www.excelforum.com/member.php...o&userid=25330
View this thread: http://www.excelforum.com/showthread...hreadid=388108