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
<colgroup><col></colgroup><tbody>
</tbody>
lookup table
<colgroup><col width="64" style="width:48pt"> </colgroup><tbody>
</tbody>
Test Results
<colgroup><col><col></colgroup><tbody>
</tbody>
thanks for any help.
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
IC-Beleg 2272209 buchen / BUK= CH12 LF=df-mp |
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))) |
<colgroup><col></colgroup><tbody>
</tbody>
lookup table
Company Codes |
CH |
BE |
CZ |
DE |
DK |
ES08 |
FR07 |
GB |
NL03 |
NL07 |
US06 |
<colgroup><col width="64" style="width:48pt"> </colgroup><tbody>
</tbody>
Test Results
Complete IC-document 2272507 / BUK= FR07 LF=Rpc Superfos La Genete | FR07 |
Complete IC-document 2272198 / BUK= ES08 LF=Extra Transp.Internacionais Lda | ES08 |
Complete IC-document 2272198 / BUK= ES08 LF=Extra Transp.Internacionais Lda | ES08 |
IC-Beleg 2272209 buchen / BUK= CH12 LF=df-mp | DE |
Complete IC-document 2266090 / BUK= GB01 LF=company | GB |
Complete IC-document 2272508 / BUK= FR07 LF=Rpc Superfos La Genete | FR07 |
Complete IC-document 2272475 / BUK= ES08 LF=Reclamos Vigo, S.L. | ES08 |
Complete IC-document 2271331 / BUK= US06 LF=Iron Mountain/Safesite Inc. | US06 |
Complete IC-document 2271336 / BUK= US06 LF= | US06 |
Complete IC-document 2271347 / BUK= US06 LF=Parker, Holly PC Custodian | US06 |
<colgroup><col><col></colgroup><tbody>
</tbody>
thanks for any help.