Lookup Help

[Brento]

HI,

I need assistance with this query. I have a Table of data displaye
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 manua
date in put and e2 which will be a manual time input but varys aroun
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
cell for that 3 day period of data.

thanks in advance
Brent

 

[Biff]

Hi!

As long as the times listed in column A are in ascending order (like they
are in your sample):

=IF(COUNT(E1,E2)=2,VLOOKUP(E2,A25,MATCH(E1,A11,0)),"")

Any time criteria <8:30 will return #N/A.
Any time criteria >9:15 will return the last value from the corresponding
column.

Biff

 

[RagDyeR]

Try this:

=INDEX(B25,MATCH(E2,A2:A5),MATCH(E1,B11,0))

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================


message
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