Yes, I see, one can always learn better solutions!

Regards,
Stefi


€žBob Phillips€� ezt Ã*rta:

Surely better to use

MATCH($C2,$B$1:$B$10,0)

than

VLOOKUP($C2,$B$1:$B$10,1,FALSE)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Stefi" wrote in message
...
Hi Ramana,

Apply a dummy first row in your table with B1=0:00
and try this in D2:

=IF(ISERROR(VLOOKUP($C2,$B$1:$B$10,1,FALSE)),LOOKU P($C2,$B$1:$B$10,$A$1:$A$1
0)+1,LOOKUP($C2,$B$1:$B$10,$A$1:$A$10))

Regards,
Stefi

"ramana" ezt Ã*rta:

My formula lokks like this.

D1=lookup($C1,$B$1:$B$10,$A$1:$A$$10)

but the problem is it is returning me the cell value which is less thsn
that I'm looking for In the above example, for 8:10 in column C it
should return me a value 5 but it is returning 4. I think now you can
understand the problem.

Thanks and Regards

Ramana