Search String and Return values

[Bibinp]

Here i paste one excel report. In this, In need to make a report form a Master data with search keys.. please find the attached file and help me please...
thanks in advance..

Master Data
Item No.	Name	Code	Price	Cat.
245	Apple Red	UK	1.50	10
4157	Orange Naval USA	USA	1.30	11
1479	Glove	hand	2.00	33
22	Apple Green Italy	Italy	1.20	10
584	m. Water	Mineral	1.00	22
589961	Orange Juice500ml	Juice	1.00	15
146211	Drinkeing Water	Bottle	1.70	22
58	Sauce3oz	Sauce	1.70	20
8887	Mix veg	veg	1.60	45
4572	G.Duck	Duck	3.20	46

<tbody>
</tbody>

<tbody>
</tbody>

____

Data		SearchKey
Item No.	Name
245	Apple Red		Red
4157	Orange Naval USA		usa
1479	Glove
22	Apple Green Italy		red
584	m. Water		m.
589961	Orange Juice500ml		500
146211	Drinkeing Water		drin
58	Sauce3oz		oz

<tbody>
</tbody>

_____

Reuslt (Cat. Wise)
Name	Code	Price	Cat.
Apple Red	UK	1.50	10
Apple Green Italy	Italy	1.20	10
Orange Naval USA	USA	1.30	11
Orange Juice500ml	Juice	1.00	15
Sauce3oz	Sauce	1.70	20
m. Water	Mineral	1.00	22
Drinkeing Water	Bottle	1.70	22

<tbody>
</tbody>

_____


for reference see the image link : https://ibb.co/kDBGhR

 

[davesexcel]

Your descriptions are confusing.
How are you searching for the item?

 

[Bibinp]

i put one column name with search key.. with this search key i need to find the matched items
sorry for the in confusing.. can u please check the image link..