I am looking up a date in a cell in a table, then the number of cells I go over in the table is determined by if the date is before march 1st 2005 or after. It simply won't return the correct value. Here is the formula I'm using: =IF($A8<$T$7,VLOOKUP(E8,all,2,VLOOKUP(E8,all,3))) variables are: A8 (date), T7 (3/1/2005), E8 (number of years calculated by today's date - date in A8), all (table with year, hrs if before, hrs if after)