# vlookup returning zeros

C

#### Cobaum

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.

M

#### Max

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
xdemechanik

C

#### Cobaum

Yes, it is absolute.

Max said:
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
xdemechanik

M

#### Max

In your other similar posting in .misc,
but where you indicated your formula:
=VLOOKUP(A6,'[2008 Projection.xls]08 PROJ'!A\$9:C\$191,3)

My thoughts were:

As-is, you need to ensure that the values in the table array's lookup col
are sorted in ascending order

Alternatively, amend it for exact matching, viz.:
=VLOOKUP(A6,'[2008 Projection.xls]08 PROJ'!A\$9:C\$191,3,0)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

C

#### Cobaum

Max, I could kiss you on the mouth. AWESOME. If ever in Denver, I'll buy
you a beer!

Max said:
In your other similar posting in .misc,
but where you indicated your formula:
=VLOOKUP(A6,'[2008 Projection.xls]08 PROJ'!A\$9:C\$191,3)

My thoughts were:

As-is, you need to ensure that the values in the table array's lookup col
are sorted in ascending order

Alternatively, amend it for exact matching, viz.:
=VLOOKUP(A6,'[2008 Projection.xls]08 PROJ'!A\$9:C\$191,3,0)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
Cobaum said:
Yes, it is absolute.

M