I've tried both and can't get it to work. Here's my code:
=INDEX(WTVF!$B$2:$EX$97,MATCH(E3,WTVF!$B$1:$EX$1,0 ),MATCH(G3,WTVF!$A$2:$A$97,0))

where the sheet name is 'WTVF' and the data lives in cells B2:EX97,
dates are in the top row B1:EX1, and times are in A2:A97. On the
second sheet, my date is in E3, and my time is in G3, with the formula
in L3.

I've tried this also as an array, but to no avail.

Any further assistance is appreciated.

Thanks!


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