"Bernie Deitrick" <deitbe @ consumer dot org wrote...
Put your list of 7 words in F2:F8, and the abbreviations in G2:G8.

Then, in B4, array enter (enter using Ctrl-Shift-Enter)

=INDEX($G:G,MIN(IF(ISERROR(SEARCH($F$2:$F$8,A4)), 1000,ROW($F$2:$F$8))))

and copy down to match column A.
....

If one and only one of the 7 words would appear in each cell in col A,
then with the same setup in F2:G8, this could be done using the
formula

=LOOKUP(2,1/SEARCH($F$2:$F$8,A4),$G$2:$G$8)