I tried this and I am getting a 0 rather than the abbreviation.

=LOOKUP(2,1/ISNUMBER(SEARCH(" "&$B$2:$B$10&" ",A2)),$C$2:$C$10)