Hi
I know I need to use inde/match, but I am having trouble putting it all
together.

A1= 01/01/2006 05:00
I have a lookup grid as follows:
A3:A33 = dates 01/01/2006-01/31/2006
B2:Y2 =Hours 1-24

This is what I have so far (That wont work)
=index(B3:Y33,match(TEXT(A9,"dd/mm/yyyy"),A3:A33)*(hour(A9),B2:Y2,1))

Thanks!