vlookup returning zeros
 

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.

vlookup returning zeros
 

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.

vlookup returning zeros
 

Yes, it is absolute.

"Max" wrote:

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.

vlookup returning zeros
 

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 we

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
Downloads:17,500 Files:358 Subscribers:55
xdemechanik
---
"Cobaum" wrote in message
...
Yes, it is absolute.

vlookup returning zeros
 

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

"Max" wrote:

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 we

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
Downloads:17,500 Files:358 Subscribers:55
xdemechanik
---
"Cobaum" wrote in message
...
Yes, it is absolute.

vlookup returning zeros
 

Welcome. A brotherly hug will do, but I'll take the beer.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,500 Files:358 Subscribers:55
xdemechanik
---
"Cobaum" wrote in message
...
Max, I could kiss you on the mouth. AWESOME. If ever in Denver, I'll buy
you a beer!