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.