lookup with one result show 0 only: funny bug attached file

Hi all,

I have this lookup formula with one result only.

=lookup(a1,b1:b10,c1)

say a1 = 2-10,
b1:10 = 1 to 10
c1 = 100

a1 = 1 is ok.

Tried =lookup(a1,b1:b10,c1:c1) not working.

Result shows 0 and not the value.

Is there any way to show the value not the 0?