How to extract exact words to a different cell, errors in formula

[Dave01]

So I have two text strings, in seperate lengths, I want my formula to be able to pick up the CH12 or GB01 and copy it to a different cell.
I am tring to get it to go through a Vlookup as there are a lot of company codes. Ideally what I would like it to do is to look at the text string finds the CH12, and outputs just the CH12 to another cell.

Column B
[TABLE="width: 516"]
<colgroup><col></colgroup><tbody>[TR]
[TD]IC-Beleg 2272209 buchen / BUK= CH12 LF=df-mp[/TD]
[/TR]
[TR]
[TD]Complete IC-document 2266090 / BUK= GB01 LF=company

This is the closest I got, but it sometimes reports back the wrong results

=INDEX(Maintance!$A$1:$A$12,SUM(COUNTIF($B2801,"*"&Maintance!$A$1:$A$12&"*")*ROW(Maintance!$A$1:$A$12)))[/TD]
[/TR]
</tbody>[/TABLE]

lookup table

[TABLE="width: 64"]
<colgroup><col width="64" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl72, width: 64"]Company Codes[/TD]
[/TR]
[TR]
[TD]CH[/TD]
[/TR]
[TR]
[TD]BE[/TD]
[/TR]
[TR]
[TD]CZ[/TD]
[/TR]
[TR]
[TD]DE[/TD]
[/TR]
[TR]
[TD]DK[/TD]
[/TR]
[TR]
[TD="class: xl71"]ES08[/TD]
[/TR]
[TR]
[TD]FR07[/TD]
[/TR]
[TR]
[TD]GB[/TD]
[/TR]
[TR]
[TD]NL03[/TD]
[/TR]
[TR]
[TD]NL07[/TD]
[/TR]
[TR]
[TD]US06[/TD]
[/TR]
</tbody>[/TABLE]


Test Results

[TABLE="width: 1069"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]Complete IC-document 2272507 / BUK= FR07 LF=Rpc Superfos La Genete[/TD]
[TD]FR07[/TD]
[/TR]
[TR]
[TD]Complete IC-document 2272198 / BUK= ES08 LF=Extra Transp.Internacionais Lda[/TD]
[TD]ES08[/TD]
[/TR]
[TR]
[TD]Complete IC-document 2272198 / BUK= ES08 LF=Extra Transp.Internacionais Lda[/TD]
[TD]ES08[/TD]
[/TR]
[TR]
[TD]IC-Beleg 2272209 buchen / BUK= CH12 LF=df-mp[/TD]
[TD]DE[/TD]
[/TR]
[TR]
[TD]Complete IC-document 2266090 / BUK= GB01 LF=company[/TD]
[TD]GB[/TD]
[/TR]
[TR]
[TD]Complete IC-document 2272508 / BUK= FR07 LF=Rpc Superfos La Genete[/TD]
[TD]FR07[/TD]
[/TR]
[TR]
[TD]Complete IC-document 2272475 / BUK= ES08 LF=Reclamos Vigo, S.L.[/TD]
[TD]ES08[/TD]
[/TR]
[TR]
[TD]Complete IC-document 2271331 / BUK= US06 LF=Iron Mountain/Safesite Inc.[/TD]
[TD]US06[/TD]
[/TR]
[TR]
[TD]Complete IC-document 2271336 / BUK= US06 LF=[/TD]
[TD]US06[/TD]
[/TR]
[TR]
[TD]Complete IC-document 2271347 / BUK= US06 LF=Parker, Holly PC Custodian[/TD]
[TD]US06[/TD]
[/TR]
</tbody>[/TABLE]

thanks for any help.

 

[Dave01]

I could get away with the vlookup, It just needs to extract the text.

 

[Dave01]

=MID(B53,SEARCH("=",B53)+1,SEARCH("=",B53,SEARCH("=",B53)+1)-SEARCH("=",B53)-3)

Ive done it