HI,

I need assistance with this query. I have a Table of data displayed
below
a1 b1 c1 d1
13/08/06 14/08/06 15/08/06
08:30 24 123 233
08:45 78 46 176
09:00 98 122 322
09:15 101 146 244

I need a formula to say if date displayed in e1 which will be a manual
date in put and e2 which will be a manual time input but varys around
and not a spot on 15 minute time. then display value in the cell.

Example e1= 14/08/06 e2= 09:01 e3 (the result) = 122.

I think it is a vllokup formula but not sure how to put it all in 1
cell for that 3 day period of data.

thanks in advance
Brento


--
Brento
------------------------------------------------------------------------
Brento's Profile: http://www.excelforum.com/member.php...o&userid=25213
View this thread: http://www.excelforum.com/showthread...hreadid=571085