|
| 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
August 28th, 2008, 07:38 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
August 28th, 2008, 07:52 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
August 28th, 2008, 08:17 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
August 28th, 2008, 08:22 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
August 28th, 2008, 08:50 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
August 28th, 2008, 11:43 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 | |
|
|
Linear Mode
