Did you ensure that the vlookup's table array is fixed (made absolute with $
signs), before you copied down?

Eg the "Sheet2!$A$2:$B$5000" bit in:
=VLOOKUP(A2,Sheet2!$A$2:$B$5000,2,0)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,500 Files:358 Subscribers:55
xdemechanik
---
"Cobaum" wrote:
I have a vlookup formula that I copied down a column. It works fine on 95%
of the values, but for some reason, right in the middle of the column it is
giving me zeros for six of the cells. I checked to make certain the lookup
values were identical in each sheet and they are. The lookup values are
simple four digit numbers. I have retyped the numbers as both the lookup
value and the array and I still get zeros. Any help would be appreciated.