Error when Sorting data with INDEX Formula

Hi,
I've got large set of data(Column E) for dates from 2007 to 2013(Column B). Here dates are in chronological order.(Attachement)
Now I want to match the data in to dates in Column H. Here dates are in random order. I used =INDEX(E3:E40582; MATCH(H3;B3:B40582; 0)). But it doesn't work. Kindly help me.Thank you.

Forumla is applied in column J. Matching is not occured and it gives zero for all dates. But all the values are not zero in column E.

Hi, you are missing $ signs in your formulas I think, for your formula you might need to look up at the hour as well. I guess you could do:
=INDEX(E3:E40582, MATCH(H3&I3,B$3:B$40582&C$3:C$40582, 0))
but it would likely take a very long time to calculate on that data set, you might be better with
=INDEX(E$3:E$40607, MATCH(H3,B$3:B$40607, 0)+I3)
if your data is chronological.

Hi ragulduy,

Thank you very much. But still it doesn't work. I applied =INDEX(E$3:E$40582; MATCH(H3;B$3:B$40582; 0)) with $ mark.

See rest of post #3 and try:
=INDEX(E$3:E$40607, MATCH(H3,B$3:B$40607, 0)+I3)

Yes, Many thanks. It works.
I am sorry, I coud not try it.
Great.