Having trouble with vlookup and mid function

[titoexcel]

I have the following list in

column A:

CO-006-8602790

CO-006-8613249

CO-006-8613781

CO-009-0023846

CO-009-0024750

CO-009-0025424

CO-497-0461171 I am trying to use it in the following format : =vlookup(mid(A2,4,11)+0,range,column,match type) I have my corresponding columns in a different worksheet and need to bring value back, What am I doing wrong? Thank you

<tbody>
</tbody><colgroup><col></colgroup>

 

[Stan_C]

What does the range of data look like that you're referencing?

 

[Sixthsense]

Replace mid(A2,4,11)+0 with =SUBSTITUTE(MID(A2,4,11),"-","")+0

<colgroup> </colgroup><tbody> </tbody>

 

[Teeroy]

With [mid(A2,4,11)+0] you are trying to add a number to a string. If you are trying to append a trailing zero onto the string (after dropping the "CO-") then use "&" instead of "+".