Excel partial match from unequal columns and assign value to new column.

[xjabbott]

I want to assign a category to a table so that I can eventually create a pivot table.
I need to do a partial match to get my category values.
"num" i want to match to "number 111" and "numeric 321" and then assign both of those as category1.
"form" i want to match to "Form 1" and "formula" as category2 and so on.

Group	Assigned catorgories		Matching critera	Categories
Number 111			num	category1
Numeric 321			form	category2
Form 1			data	category3
Uncategorized			misc	category4
test data
prod data
formula

<tbody>
</tbody>

 

[Bo_Ry]

Please try
B2
=LOOKUP(0,-SEARCH($D$2:$D$5,A2),$E$2:$E$5)
or
Uncategorized => category4
=IFERROR(LOOKUP(0,-SEARCH($D$2:$D$5,A2),$E$2:$E$5),$E$5)

 

[xjabbott]

Thanks Bo_Ry... that worked... I was so sunk into vlookup or index and match that I didn't consider lookup.