Referencing date column A & time column B to get info from column
You have too many MATCH functions.
Column A = date
Column B = time
Column C = program
E1 = 1/6/2008
F1 = 11:00 PM
Try this:
=INDEX(C1:C999,MATCH(E1+F1,INDEX(A1:A999+B1:B999,, 1),0))
Just plug in your sheet names and the file name.
--
Biff
Microsoft Excel MVP
"TVGuy29" wrote in message
...
Hello! i have what seems to be a fairly simple task, and I think i'm
close,
but im not quite there, and I was looking for some advice.
I have a spreadsheet I'm working on, and I want to tell Excel to look for
the date (such as 1/6/2008) in column A, then i want it to look for the
time
(such as 11:00 PM) in column B. When it finds a match for those two
parameters, i want it to display the inforation listed in column C. Which
in
this case would be the name of a television show. (1/6/2008 (column A)
+
11:00 PM (column B) = Knight Rider (column C))
Here's the formula i am working on. Currently it returns a message of
"#N/A".
=INDEX('[January 08 Calendar.xls]Sheet1'!$A$1:$D$999, MATCH(C2,'[January
08
Calendar.xls]Sheet1'!$A$1:$A$999,0), MATCH(B4,'[January 08
Calendar.xls]Sheet1'!$A$1:$A$999,0), MATCH("Showname",'[January 08
Calendar.xls]Sheet1'!$D$1:$E$1,0))
Can anyone help with the next step?
|