I have been at this for a long time and I know I have to be missing something
small, hopefully small, this is what I am trying to do for a work
spreadsheet when costing some jobs, I need to use vlookup which is working
but not fully, I need a formula to say, If the date is <9/20/2005 then look
up the rate in the column 1, but if the date is greater then 9/20/2005 then
look up the rate in column 2, it is looking up the rate but when the date is
changing it does not change the formula to the correct rate. PLEASE HELP!!!