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
[TABLE="width: 500"]
<tbody>[TR]
[TD]Happy
[/TD]
[/TR]
[TR]
[TD]Sad
[/TD]
[/TR]
[TR]
[TD]Cry[/TD]
[/TR]
</tbody>[/TABLE]


[TABLE="width: 500"]
<tbody>[TR]
[TD]Description[/TD]
[TD]Return Matches[/TD]
[/TR]
[TR]
[TD]Happy Person[/TD]
[TD]Happy[/TD]
[/TR]
[TR]
[TD]Person is Happy[/TD]
[TD]Happy[/TD]
[/TR]
[TR]
[TD]Two Sad Persons[/TD]
[TD]Sad[/TD]
[/TR]
[TR]
[TD]A Cry Person[/TD]
[TD]Cry[/TD]
[/TR]
</tbody>[/TABLE]

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)