Try

=INDEX(B3:Y33,MATCH(INT(A1),A3:A33,0),MATCH(HOUR(A 1),B2:Y2,0))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Bobby" wrote in message
...
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!