Thread: vblookup and hblookup combo problem

Hi everyone,

I have 2 worksheets. One (#1) has data automatically added and appended daily, the second (#2) is a worksheet where the data is analyzed.

I need to get one value from #1 into #2.

Worksheet #1 is set up like this

A B C
1..date..............time....level
2..12/01/2010....0:00......1
3 ....................1:00 .....2
4......................2:00......3
5......................3:00......4

...and so on.

The date is only displayed next to midnight.

I'm hoping I could use VBlookup to find the date, go down to 3:00 then use hblookup to go horizontally to column C and then display "4"

So far I have no luck. Hopefully my question is clear and any help or suggestions are greatly appreciated.

thanks

=INDEX(sheet1!C1:C100,MATCH(E1,sheet1!A1:A100,0)+3)
where E1= your date