I am trying to do an hlookup with a date that is giving me trouble.
I have about 250 lines of dates that are in m-y format.
I have a table which I want it to do an hlookup into row 21 based on whichever year it is (2006 - 2010). The problem that i can't figure out is that for example in October 2008, it is picking up the 2010 (bc of the 10 associated with October I believe) rather than the 2008. Any assistance is greatly appreciated.
Thanks,
Dan
I have about 250 lines of dates that are in m-y format.
I have a table which I want it to do an hlookup into row 21 based on whichever year it is (2006 - 2010). The problem that i can't figure out is that for example in October 2008, it is picking up the 2010 (bc of the 10 associated with October I believe) rather than the 2008. Any assistance is greatly appreciated.
Thanks,
Dan