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)
Column A Column B (blank) The bucket e(5) was full The broom stood The call came d(4)
List B (The reference list - e.g., "does list A contain any of these items")
Column A Column B d(4) d(4) Yeah e(5) e(5) No! f(6) f(6) Ok
Final Product: What I need the final product to look like:
Coumn A - from List A Column B - Added text from List B The bucket e(5) was full e(5) No! The broom stood The call came d(4) d(4) Yeah