You need to look at the match function and the index or offset function

If the column heading are in sheet1 d6:h6 and are dates and the row
headings are in c7:c16 and are times

and in the second sheet the first column is time and the second is date
and you are in cell c2 on the scond sheet try

=INDEX(Sheet1!$D$7:$H$16,MATCH(A2,Sheet1!$C$7:$C$1 6,0),MATCH(B2,Sheet1!$D$6:$H$6,0))

or

=offset(sheet1!$c$6,MATCH(A2,Sheet1!$C$7:$C$16,0), MATCH(B2,Sheet1!$D$6:$H$6,0))

In both instances I have assumed an exact match, if it the value
nearest above or below the formula needs to be ammended

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=564172