Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 24th 08, 10:36 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2008
Posts: 4
Default 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   Report Post  
Old January 24th 08, 10:50 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2006
Posts: 15,768
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Consolidate information from Column B Based on Info In Column A Consol. Info from One Column to another Excel Worksheet Functions 1 October 27th 07 04:02 PM
Finding Info from Column A and Removing it from Column B Johnny B[_2_] Excel Discussion (Misc queries) 2 March 28th 07 12:06 PM
Using a date range in a formula to pull info to the correct column Tricia Excel Worksheet Functions 6 December 13th 06 11:16 PM
combine date one column, with time another column into third? psalyers Excel Worksheet Functions 2 August 23rd 05 08:05 PM
how do I convert a date and time column to a time column thdorsky2 Excel Worksheet Functions 1 March 4th 05 09:49 PM


All times are GMT +1. The time now is 07:09 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017