Thanks for this, though I am not sure I understand how to do that.

I have created a column with the "codes" in like FMT, T&T (by the way I
would prefer to use Financial Markets and Technology and Telecoms if
possible) and then made a column next to that with the name codes FM, TT
etc; but I am not sure where to go from there with this vlookup thing.

A

--
Message posted via http://www.officekb.com