Vlookup returning zeros

[wilbur00]

Hello -

I have a column of percentages (monthly values) and am looking up the data in the last cell in that column that has a value in it (as the months progress different cells are populated). The formula is vlookup(9.9999999E+307,C1:C12). The sheet has 18 different columns and I want to do a vlookup to find the last populated value in each of the 18 columns, but after I do 10 lookups the next lookup returns 0. Is there a limit to the number of vlookups you can do on one worksheet?

Data looks like:

lookup results-> 95.7 94.3 96.8

Dept A Dept B .... Dept R
January 99.3 94.5 97.6
February 95.7 94.3 96.8
March 0 0 0
April 0 0 0
May 0 0 0
June 0 0 0
July 0 0 0
August 0 0 0
September 0 0 0
October 0 0 0
November 0 0 0
December 0 0 0

 

[SkipVought]

Hi,

Make the lookup range ABSOLUTE
[tt]
$C$1:$C$12
[/tt]


Skip,

_{Have you heard that the roundest knight at King Arthur's round table was...
Sir Cumference!}