lookup formula need help

[vikas2424]

i have data in a1:a100, b1:b100, c1:100

if c1 data mach between b1:b100 in any cell then paste result front that cell (from a1:a100)

example

if c1 data mach in b5 then paste a5
if c10 data mach in b20 then paste a20

[Bishonen]

Lookup is an excel function not a vba property.
That being said, type this into d1 and drag down:

=LOOKUP(C1,$B$1:$B$100,$A$1:$A$100)

[vikas2424]

thank's very much it's working

[vikas2424]

sorry sir it's not working now

if c1 data mach in b5 then only past a5 ans.other wise past as 0

but your formula give me ans. if not mach c1 wth b5

and in coluam c and b there is time value (11:01:01)

[Bishonen]

I'm not really sure whether I understand you correctly, but if you meant that in a case where no match is found, the formula still displays some results then try this please:

=IFERROR(INDEX($A$1:$A$100, MATCH(C1,$B$1:$B$100,0)),"")

This goes into C1 and has to be dragged down