Hlookup Question (Easy I think)

geffen5

New Member
Joined
Aug 23, 2006
Messages
10
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
 

Some videos you may like

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

Watch MrExcel Video

Forum statistics

Threads
1,109,540
Messages
5,529,434
Members
409,876
Latest member
Akash Yadav
Top