Matching list in table

[erdist]

I am trying to shortlist a table by matching information from a list, and would appreciate your help. The list and the table are variable in size and content, the location in the table where the list members can be found also varies. Below is a simplified example of what I am looking at and what I would like to achieve. Thanks in advance!


[TABLE="width: 504"]
<tbody>[TR]
[TD]List[/TD]
[TD]-------------
[/TD]
[TD]Match Result
[/TD]
[TD]Table[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]apple[/TD]
[TD][/TD]
[TD]Yes[/TD]
[TD]banana[/TD]
[TD]apple[/TD]
[TD]aasd[/TD]
[/TR]
[TR]
[TD]banana[/TD]
[TD][/TD]
[TD]Yes[/TD]
[TD]jjj apple asdasd[/TD]
[TD]asdf[/TD]
[TD]fdas[/TD]
[/TR]
[TR]
[TD]pear[/TD]
[TD][/TD]
[TD]Yes[/TD]
[TD]asdf[/TD]
[TD]dds coconut[/TD]
[TD]asdfsd[/TD]
[/TR]
[TR]
[TD]coconut[/TD]
[TD][/TD]
[TD]No[/TD]
[TD]gdsa[/TD]
[TD]sssdf[/TD]
[TD]sds[/TD]
[/TR]
</tbody>[/TABLE]
berry
fruit