Vlookup within a time range

[d_lister]

Hi,

I am new here although I have used it the forum as a guest a few times.

I have a problem and am not sure it is possible but if I am just not good enough.

On sheet 1 I have data in chronological order wit start and end date and time.

On sheet 2 I have other information by date and time. I am now trying to link the Sheet two times to the ranges defined on sheet 1. When using "TRUE", it gives me the wrong bit of information (the one above).

Any help would be much appreciated. I will try and upload a sample once I found out how

Thanks

Christopher

P.S.: I use Excel 2007

Sheet 1:

Start time End Time Data
1/12/09 06:00 1/12/09 06:18 b5648

Sheet 2:

Time Data2 Data???
1/12/09 06:06 790 (B5648)

 

[d_lister]

Just to add a few more bits of data,

Sheet 1:

Excel Workbook
	A	B	C
1	Start Time	End Time	Info
2	01/12/2008 05:57	01/12/2008 06:18	B6169
3	01/12/2008 06:18	01/12/2008 06:23	B6170
4	01/12/2008 06:23	01/12/2008 06:50	B6165
5	01/12/2008 06:50	01/12/2008 07:20	B5021
6	01/12/2008 07:20	01/12/2008 07:55	B5022
7	01/12/2008 07:55	01/12/2008 08:09	B6172
8	01/12/2008 08:09	01/12/2008 08:52	B6166
9	01/12/2008 08:52	01/12/2008 09:06	B4046
10	01/12/2008 09:06	01/12/2008 09:23	B4181
11	01/12/2008 09:23	01/12/2008 09:59	C3025
12	01/12/2008 09:59	01/12/2008 10:09	C6310
13	01/12/2008 10:09	01/12/2008 10:22	C6210
14	01/12/2008 10:22	01/12/2008 10:27	C1598
15	01/12/2008 10:27	01/12/2008 10:38	C6324
Sheet1

Excel Tabellen im Web darstellen >> http://www.excel-jeanie-html.de" target="_blank"> Excel Jeanie HTML 4

Sheet 2:

Excel Workbook
	A	B	C	D
1	Date	Data	Date in Text	Vlookup
2	01/12/2008 06:18	6,030	01/12/2008 06:18	B6169
3	01/12/2008 06:18	4,372	01/12/2008 06:18	B6169
4	01/12/2008 06:18	8,026	01/12/2008 06:18	B6169
5	01/12/2008 06:18	273	01/12/2008 06:18	B6169
6	01/12/2008 06:23	2,399	01/12/2008 06:23	B6170
7	01/12/2008 06:23	482	01/12/2008 06:23	B6170
8	01/12/2008 06:23	2,593	01/12/2008 06:23	B6170
9	01/12/2008 06:29	3,528	01/12/2008 06:29	B6170
10	01/12/2008 06:29	70	01/12/2008 06:29	B6170
11	01/12/2008 06:29	39	01/12/2008 06:29	B6170
12	01/12/2008 06:37	4,352	01/12/2008 06:37	B6170
13	01/12/2008 06:37	513	01/12/2008 06:37	B6170
14	01/12/2008 06:37	62	01/12/2008 06:37	B6170
15	01/12/2008 06:42	9,884	01/12/2008 06:42	B6170
16	01/12/2008 06:42	431	01/12/2008 06:42	B6170
17	01/12/2008 06:42	39	01/12/2008 06:42	B6170
18	01/12/2008 06:45	3,397	01/12/2008 06:45	B6170
19	01/12/2008 06:45	25	01/12/2008 06:45	B6170
20	01/12/2008 06:45	39	01/12/2008 06:45	B6170
21	01/12/2008 06:50	5,471	01/12/2008 06:50	B6165
22	01/12/2008 06:50	5,226	01/12/2008 06:50	B6165
23	01/12/2008 06:50	2,693	01/12/2008 06:50	B6165
24	01/12/2008 07:00	5,268	01/12/2008 07:00	B6165
25	01/12/2008 07:00	615	01/12/2008 07:00	B6165
Sheet2

The formula so far in column D on sheet 2 is "=VLOOKUP(C2,Info,2,TRUE)"

Ifo is defined as B1:C288

Hope that helps a little more.