Member Avatar for Jeffrey_1

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 by Jeffrey_1
  • 1 Contributor
  • 1 Reply
  • 213 Views
  • 1 Hour Discussion Span
  • Latest Post Latest Post by Jeffrey_1
Member Avatar for 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
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.