I need to search the content from one list (List A, Column A) for the mention of items from another list (List B, Column A), and if any matches are found, I need to publish in Column B of List A the data from Column B of the associated matching item of List B. Can anyone help?
Tables below to help clarify what I'm asking.
List A (The list being searched)
<tbody>
</tbody>
List B (The reference list - e.g., "does list A contain any of these items")
<tbody>
</tbody>
What I need the final product to look like:
<tbody>
</tbody>
Tables below to help clarify what I'm asking.
List A (The list being searched)
List A | Column B (blank) |
The bucket e(5) was full | |
The broom stood | |
The call came d(4) |
<tbody>
</tbody>
List B (The reference list - e.g., "does list A contain any of these items")
List B | Column B |
d(4) | d(4) Yeah |
e(5) | e(5) No! |
f(6) | f(6) Ok |
<tbody>
</tbody>
What I need the final product to look like:
List A | Added text from List B, Column B |
The bucket e(5) was full | e(5) No! |
The broom stood | |
The call came d(4) | d(4) Yeah |
<tbody>
</tbody>