I have a number of company names in an excel spreadsheet like this.
<colgroup><col></colgroup><tbody>
Aceto CorpAZJ:BER
Petra Diamonds LtdPDL:LSE
<colgroup><col></colgroup><tbody>
OutokumpuOUT1V:HEX
</tbody>
</tbody>
I want to do a VLOOKUP to the following list
AZJ
PDL
OUT1V
Can...