Searching content of a cell in multiple cells

Tesla · #1 03-25-2019, 02:03 AM

Greetings,
I am looking for your support. I have a content of one sheet that I want to look for in on another sheet (in a larger text). If I find that content, I want to display a corresponding name of report that is next to the content I am looking for. For clarity please find attached example, Thank you for your support.

Marcia · #2 03-25-2019, 06:03 AM

If the unique identifier is column A, try this formula in C3 of sheet 1, copy down.

=VLOOKUP(A3,sheet2!A:C,3,FALSE)

Tesla · #3 03-25-2019, 07:34 AM

Thank you for your answer, but the unique identifier is not the s/n. In fact I am looking for the sentence in a paragraph. If that sentence is found, then the function should return the name of a report in which that paragraph is located.

Marcia · #4 03-25-2019, 08:13 AM

Ooops If you mean you want a formula to find the string of words (sentence) in column B of sheet 1 from a paragraph in column B of sheet 2 then return the matching report number, I'm afraid that's beyond my knowledge.

xor · #5 03-25-2019, 10:54 AM

Maybe like this.

Tesla · #6 03-25-2019, 10:14 PM

Thank you Xor. It looks like is the answer to my problem, but I have to take time to learn it. Thank you very much again

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Generate content in 3rd cell from drop down lists in 2 other cells	Paulmnz	Word VBA	2	03-12-2018 04:48 PM
convert list in one cell into multiple cells	RayK	Excel	2	02-09-2016 04:53 AM
How to modify the figures and cell format in multiple cells at once?	officeboy09	Excel	5	01-16-2014 07:41 PM
Allow Multiple Content Control same cell of form table	DeborahBartlett	Word	1	01-04-2014 11:06 AM
Copy table cell formatting across multiple cells / tables	pakistanray	Word Tables	2	10-31-2011 08:07 AM