View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Eric Eric is offline
external usenet poster
 
Posts: 1,670
Default How to use index and match function for determining the value?

Does anyone have any suggestions on how to use index and match function for
determining the value?

Under the column A, there is a list of number,
Under the column B, there is a list of date,
Under the column C, there is a list of time,

1 3-Aug-09 10:15 AM [row 14]
2 3-Aug-09 10:30 AM
3 3-Aug-09 10:45 AM
4 3-Aug-09 11:00 AM
5 3-Aug-09 11:15 AM
6 3-Aug-09 11:30 AM
7 3-Aug-09 11:45 AM
8 3-Aug-09 12:00 PM
9 3-Aug-09 12:15 PM [row 22]

There is a given date in cell C1 3-Aug-09, and
there is a given time in cell C2 11:15 PM
I would like to determine the value under column A, which match both of the
date and time, and it should return 5 in cell C10.

Does anyone have any suggestions on how to do it in Excel?
Thanks in advance for any suggestions
Eric