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

Edited 2 Years Ago by Jeffrey_1

Just realized that some cells have more that one notation in them as well, such as the first line below, so those cells would need to post the result with either a "/" or an in-cell paragraph break to include both associated values in the cell (again, like the below output). Thoughts?

List A

Column A                        Column B (blank)
The bucket e(5) was full f(6)   
The broom stood 
The call came d(4)

Output

Coumn A - from List A           Column B - Added text from List B 
The bucket e(5) was full f(6)   e(5) No! / f(6) Ok
The broom stood 
The call came d(4)              d(4) Yeah
This article has been dead for over six months. Start a new discussion instead.