if a number= string to text

[deanl33069]

so i have a long number from a barcode.
0190027182300349320100024711190409210219892014g
in cells a6-a460
where the 3rd #to the 14th is fixed
90027182300349 and want cell g6-g460 output text tied to that number
so 90027182300349 would = to blue
90027182232456 would=to red
I tried the formula MID(a6,3,14)=
but cant get it to work

 

[Tom.Jones]

Re: EXTRACT part of a long number to a text answer

[TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl63, width: 64"]i have this number
01900123456789012345678901234567890

[/TD]
[/TR]
</tbody>[/TABLE]
and i am using this statment =mid(a5,3,14)
gives me 90012345678901 i want the result to be HAMMER
ty

Let's say that in column A you have that text.
Somewhere - say in column D you have those 14-digit numbers and in column E the names for each code in column D.

Now in the column - let's say - B uses the following formula:

= vlookup (-- mid($A1, 3, 14), $D$1:$E$1000, 2, 0)

 

[Tom.Jones]

Re: EXTRACT part of a long number to a text answer

If in column D are TEXT (number as text) then formula will be:

=vlookup(mid($A1,3,14), $D$1:$E$1000,2,0)