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..

[TABLE="width: 381"]
<tbody>[TR]
[TD="colspan: 5"]Master Data[/TD]
[/TR]
[TR]
[TD]Item No.[/TD]
[TD]Name[/TD]
[TD]Code[/TD]
[TD]Price[/TD]
[TD]Cat.[/TD]
[/TR]
[TR]
[TD]245[/TD]
[TD]Apple Red[/TD]
[TD]UK[/TD]
[TD="align: right"]1.50[/TD]
[TD="align: right"]10[/TD]
[/TR]
[TR]
[TD]4157[/TD]
[TD]Orange Naval USA[/TD]
[TD]USA[/TD]
[TD="align: right"]1.30[/TD]
[TD="align: right"]11[/TD]
[/TR]
[TR]
[TD]1479[/TD]
[TD]Glove[/TD]
[TD]hand[/TD]
[TD="align: right"]2.00[/TD]
[TD="align: right"]33[/TD]
[/TR]
[TR]
[TD]22[/TD]
[TD]Apple Green Italy[/TD]
[TD]Italy[/TD]
[TD="align: right"]1.20[/TD]
[TD="align: right"]10[/TD]
[/TR]
[TR]
[TD]584[/TD]
[TD]m. Water[/TD]
[TD]Mineral[/TD]
[TD="align: right"]1.00[/TD]
[TD="align: right"]22[/TD]
[/TR]
[TR]
[TD]589961[/TD]
[TD]Orange Juice500ml[/TD]
[TD]Juice[/TD]
[TD="align: right"]1.00[/TD]
[TD="align: right"]15[/TD]
[/TR]
[TR]
[TD]146211[/TD]
[TD]Drinkeing Water[/TD]
[TD]Bottle[/TD]
[TD="align: right"]1.70[/TD]
[TD="align: right"]22[/TD]
[/TR]
[TR]
[TD]58[/TD]
[TD]Sauce3oz[/TD]
[TD]Sauce[/TD]
[TD="align: right"]1.70[/TD]
[TD="align: right"]20[/TD]
[/TR]
[TR]
[TD]8887[/TD]
[TD]Mix veg[/TD]
[TD]veg[/TD]
[TD="align: right"]1.60[/TD]
[TD="align: right"]45[/TD]
[/TR]
[TR]
[TD]4572[/TD]
[TD]G.Duck[/TD]
[TD]Duck[/TD]
[TD="align: right"]3.20[/TD]
[TD="align: right"]46[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 286"]
<tbody>[TR]
[TD="colspan: 2"][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
____

[TABLE="width: 286"]
<tbody>[TR]
[TD="colspan: 2"]Data[/TD]
[TD][/TD]
[TD]SearchKey[/TD]
[/TR]
[TR]
[TD]Item No.[/TD]
[TD]Name[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]245[/TD]
[TD]Apple Red[/TD]
[TD][/TD]
[TD]Red[/TD]
[/TR]
[TR]
[TD]4157[/TD]
[TD]Orange Naval USA[/TD]
[TD][/TD]
[TD]usa[/TD]
[/TR]
[TR]
[TD]1479[/TD]
[TD]Glove[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]22[/TD]
[TD]Apple Green Italy[/TD]
[TD][/TD]
[TD]red[/TD]
[/TR]
[TR]
[TD]584[/TD]
[TD]m. Water[/TD]
[TD][/TD]
[TD]m.[/TD]
[/TR]
[TR]
[TD]589961[/TD]
[TD]Orange Juice500ml[/TD]
[TD][/TD]
[TD]500[/TD]
[/TR]
[TR]
[TD]146211[/TD]
[TD]Drinkeing Water[/TD]
[TD][/TD]
[TD]drin[/TD]
[/TR]
[TR]
[TD]58[/TD]
[TD]Sauce3oz[/TD]
[TD][/TD]
[TD]oz[/TD]
[/TR]
</tbody>[/TABLE]
_____
[TABLE="width: 317"]
<tbody>[TR]
[TD="colspan: 4"]Reuslt (Cat. Wise)[/TD]
[/TR]
[TR]
[TD]Name[/TD]
[TD]Code[/TD]
[TD]Price[/TD]
[TD]Cat.[/TD]
[/TR]
[TR]
[TD]Apple Red[/TD]
[TD]UK[/TD]
[TD="align: right"]1.50[/TD]
[TD="align: right"]10[/TD]
[/TR]
[TR]
[TD]Apple Green Italy[/TD]
[TD]Italy[/TD]
[TD="align: right"]1.20[/TD]
[TD="align: right"]10[/TD]
[/TR]
[TR]
[TD]Orange Naval USA[/TD]
[TD]USA[/TD]
[TD="align: right"]1.30[/TD]
[TD="align: right"]11[/TD]
[/TR]
[TR]
[TD]Orange Juice500ml[/TD]
[TD]Juice[/TD]
[TD="align: right"]1.00[/TD]
[TD="align: right"]15[/TD]
[/TR]
[TR]
[TD]Sauce3oz[/TD]
[TD]Sauce[/TD]
[TD="align: right"]1.70[/TD]
[TD="align: right"]20[/TD]
[/TR]
[TR]
[TD]m. Water[/TD]
[TD]Mineral[/TD]
[TD="align: right"]1.00[/TD]
[TD="align: right"]22[/TD]
[/TR]
[TR]
[TD]Drinkeing Water[/TD]
[TD]Bottle[/TD]
[TD="align: right"]1.70[/TD]
[TD="align: right"]22[/TD]
[/TR]
</tbody>[/TABLE]
_____


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..