First, thanks to Peo for helping me truncate time AND lookup all in one
formula.

Second, I'd like help with an 'intersection' formula, if possible. For
example, I have 100 rows and 100 columns, where row 1 is dates, and
column A is times, and within are numbers. On a second sheet I have a
column (A) with random dates and another (B) with times. What I need
is a third column (C)on the second sheet that looks at the date and
time, finds the intersection on the first sheet, and returns the number
found there.

Thanks in advance for any advice.
Kiley


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