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!
<tbody>
</tbody> berry
fruit
List | ------------- | Match Result | Table | ||
apple | Yes | banana | apple | aasd | |
banana | Yes | jjj apple asdasd | asdf | fdas | |
pear | Yes | asdf | dds coconut | asdfsd | |
coconut | No | gdsa | sssdf | sds |
<tbody>
</tbody>
fruit
Last edited: