Need help with formula when number string starts with zero

[becca326]

[TABLE="class: outer_border, width: 500"]
<tbody>[TR]
[TD]591611001234[/TD]
[TD]FET[/TD]
[TD]Store Depot - 461611013826 - FISH SPINNER 3.5" HEX 35007 (UOM = ea)[/TD]
[TD]3.48[/TD]
[TD]Cell with forumula. Should return "NON"[/TD]
[/TR]
[TR]
[TD]461611013826[/TD]
[TD]NON[/TD]
[TD]Store Depot - 084268105687 - FISH SPINNER 3.5" HEX 35007 (UOM = ea)[/TD]
[TD]3.48[/TD]
[TD]Cell with formula. Should return "NON"[/TD]
[/TR]
[TR]
[TD]082468105687[/TD]
[TD]NON[/TD]
[TD]Another Store Depot - 084268105687 - Different Description[/TD]
[TD]2.50[/TD]
[TD]Cell with formula. Should return "NON?[/TD]
[/TR]
</tbody>[/TABLE]

Here's the formula:

=LOOKUP(9.99999999999999E+307,SEARCH(" "&$A$1:$A$3&" "," "&C1&" "),$B$1:$B$3)

I need to be able to have excel recognize the 12-digit number in the middle of a text string in column c and match it to a value in column A and then return the column b text.

The formula works most of the time, except when the number string starts with 0. What am I doing wrong?

 

[becca326]

Ack! I miskeyed A3. Should read 084268105687.