Why is this formula returning unexpected value?

[meppwc]

The following formula exists in cell G2
=IF(C2<1,"",IFERROR(LOOKUP(2^15,SEARCH(Table!$A$2:$A$42000,A2),Table!$A$2:$A$42000),""))
The contents of cell C2 is “2”
The expected result for cell G2 is a blank cell but the formula is returning “0”

 

[jproffer]

The following formula exists in cell G2
=IF(C2<1,"",IFERROR(LOOKUP(2^15,SEARCH(Table!$A$2:$A$42000,A2),Table!$A$2:$A$42000),""))
The contents of cell C2 is “2”
The expected result for cell G2 is a blank cell but the formula is returning “0”

Why would you expect a blank cell?

 

[meppwc]

UGH
I have been at it too long...............disregard, so sorry.

 

[jproffer]

No apologies . I was beginning to think I missed something in the lookup formula that would return a "" . Hope you got it working.