How to return a value Referring to the other cell.
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
|