If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
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. |
#5
|
|||
|
|||
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. |
#6
|
|||
|
|||
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! |
Thread Tools | |
Display Modes | |
|
|