Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Referencing date column A & time column B to get info from column
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Consolidate information from Column B Based on Info In Column A | Excel Worksheet Functions | |||
Finding Info from Column A and Removing it from Column B | Excel Discussion (Misc queries) | |||
Using a date range in a formula to pull info to the correct column | Excel Worksheet Functions | |||
combine date one column, with time another column into third? | Excel Worksheet Functions | |||
how do I convert a date and time column to a time column | Excel Worksheet Functions |