Sorry it must be $A$1

=INDEX(WTVF!$A$1:$EX$97,MATCH(E3,WTVF!$B$1:$EX$1,0 ),MATCH(G3,WTVF!$A$2:$A$9**7,0))

Shail


shail wrote:
Hi tvtime

I saw all your messages posted.

I guess you have typed the function incorrect

=INDEX(WTVF!$B$2:$EX$97,MATCH(E3,WTVF!$B$1:$EX$1,0 ),MATCH(G3,WTVF!$A$2:$A$9*7,0))


If you see you need to change it this way

=INDEX(WTVF!$A$2:$EX$97,MATCH(E3,WTVF!$B$1:$EX$1,0 ),MATCH(G3,WTVF!$A$2:$A$9*7,0))


Try this one. I wish this works for you.

Thanks

Shail





tvtime wrote:
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