searching text from a table range

[winde]

Hi

is there any formula to do the following?

I have a table of text which i want to use as classification.

And i have a data table with various description. and i wan to match the description with my classification.

Classification Table

Happy

Sad

Cry

<tbody>
</tbody>

Description	Return Matches
Happy Person	Happy
Person is Happy	Happy
Two Sad Persons	Sad
A Cry Person	Cry

<tbody>
</tbody>

Thanks.

 

[AlanY]

try this

Book1
	A	B
1	Classification Table
2	Happy
3	Sad
4	Cry
5
6	Description	Return Matches
7	Happy Person	Happy
8	Person is Happy	Happy
9	Two Sad Persons	Sad
10	A Cry Person	Cry
98

Cell Formulas
Range	Formula
B7	=LOOKUP(2,1/ISNUMBER(SEARCH($A$2:$A$4,A7)),$A$2:$A$4)