What would be an example of a "specific word" in each of the example phrases
you posted?

Or is each entry in column A the "specific word"?

Maybe a lookup table and an VLOOKUP formula(s)?

See help on VLOOKUP


Gord Dibben MS Excel MVP


On Mon, 8 Dec 2008 11:09:01 -0800, Kcope8302
wrote:

Is there a functional statement that would work for my issue. I have 8
reoccuring phrases in cell A. In each of those phrases I want to search for a
specific word and once found just print the abbreviation in cell be next to
it.
Example:

A B
Functional Issues FS
Technical Issues TS
Formal Requirements FREQ
Development DEV
Testing Readiness TEST

I havent been able to find the correct IF/OR statement. Or and other method
that would provide me this functionality.

"Gary''s Student" wrote:

Say we have a list of words in column A and the translation table from H1
thru I7

Run this small macro to put the abreviations in column B:

Sub kcope()
i = 1
While Cells(i, "A").Value < ""
v = Cells(i, "A").Value
For j = 1 To 7
If v = Cells(j, "H").Value Then
Cells(i, "B").Value = Cells(j, "I").Value
Exit For
End If
Next
i = i + 1
Wend
End Sub

--
Gary''s Student - gsnu200818


"Kcope8302" wrote:

I am trying to search for specific words in column A and then print an
abbrviated version of those specific words in Column B. There is a set of 7
words that I want to search for and if one is found i want to print the
abbreviated word if not I want to move to the next word I am searching for.

I have been trying to use the If, Lookup and search functions. I have not
been successful. Example with 2 of the words I am searching for. I want this
to be one string so I can just place in column B.

=IF(SEARCH("Functional",A4),"Fs",IF(SEARCH("Techni cal",A4),"ts")