Vlookup within a time range

d_lister

New Member
Joined
Feb 25, 2009
Messages
3
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 :confused:

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)
 

Some videos you may like

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.

d_lister

New Member
Joined
Feb 25, 2009
Messages
3
Just to add a few more bits of data,

Sheet 1:

Excel Workbook
ABC
1Start TimeEnd TimeInfo
201/12/2008 05:5701/12/2008 06:18B6169
301/12/2008 06:1801/12/2008 06:23B6170
401/12/2008 06:2301/12/2008 06:50B6165
501/12/2008 06:5001/12/2008 07:20B5021
601/12/2008 07:2001/12/2008 07:55B5022
701/12/2008 07:5501/12/2008 08:09B6172
801/12/2008 08:0901/12/2008 08:52B6166
901/12/2008 08:5201/12/2008 09:06B4046
1001/12/2008 09:0601/12/2008 09:23B4181
1101/12/2008 09:2301/12/2008 09:59C3025
1201/12/2008 09:5901/12/2008 10:09C6310
1301/12/2008 10:0901/12/2008 10:22C6210
1401/12/2008 10:2201/12/2008 10:27C1598
1501/12/2008 10:2701/12/2008 10:38C6324
Sheet1
Excel Tabellen im Web darstellen >> http://www.excel-jeanie-html.de" target="_blank"> Excel Jeanie HTML 4

Sheet 2:

Excel Workbook
ABCD
1DateDataDate in TextVlookup
201/12/2008 06:186,03001/12/2008 06:18B6169
301/12/2008 06:184,37201/12/2008 06:18B6169
401/12/2008 06:188,02601/12/2008 06:18B6169
501/12/2008 06:1827301/12/2008 06:18B6169
601/12/2008 06:232,39901/12/2008 06:23B6170
701/12/2008 06:2348201/12/2008 06:23B6170
801/12/2008 06:232,59301/12/2008 06:23B6170
901/12/2008 06:293,52801/12/2008 06:29B6170
1001/12/2008 06:297001/12/2008 06:29B6170
1101/12/2008 06:293901/12/2008 06:29B6170
1201/12/2008 06:374,35201/12/2008 06:37B6170
1301/12/2008 06:3751301/12/2008 06:37B6170
1401/12/2008 06:376201/12/2008 06:37B6170
1501/12/2008 06:429,88401/12/2008 06:42B6170
1601/12/2008 06:4243101/12/2008 06:42B6170
1701/12/2008 06:423901/12/2008 06:42B6170
1801/12/2008 06:453,39701/12/2008 06:45B6170
1901/12/2008 06:452501/12/2008 06:45B6170
2001/12/2008 06:453901/12/2008 06:45B6170
2101/12/2008 06:505,47101/12/2008 06:50B6165
2201/12/2008 06:505,22601/12/2008 06:50B6165
2301/12/2008 06:502,69301/12/2008 06:50B6165
2401/12/2008 07:005,26801/12/2008 07:00B6165
2501/12/2008 07:0061501/12/2008 07:00B6165
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,101,928
Messages
5,483,745
Members
407,408
Latest member
chandika

This Week's Hot Topics

  • Finding issue in If elseif else with For each Loop
    Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
  • MsgBox Error
    Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
  • CELL FORMAT - IF CONDITION
    My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
  • Show numbers nearly the same
    Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...
  • Please i need your help to create formula
    I need a formula in cell B8 to do this >>if b1=1 then multiply ( cell b8) by 10% ,if b1=2 multiply by 20%,if=3 multiply by 30%. Thank you in...
  • Got error while adding column and filter
    Got error while adding column and filter In column Z has some like "Success" and "Error". I want to add column in AA if the Z cell value is...
Top