Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-25-2019, 02:03 AM
Tesla Tesla is offline Searching content of a cell in multiple cells Windows 7 32bit Searching content of a cell in multiple cells Office 2003
Advanced Beginner
Searching content of a cell in multiple cells
 
Join Date: Sep 2018
Posts: 59
Tesla is on a distinguished road
Default Searching content of a cell in multiple cells

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.
Attached Files
File Type: xlsx New Microsoft Office Excel Worksheet.xlsx (8.8 KB, 13 views)
Reply With Quote
  #2  
Old 03-25-2019, 06:03 AM
Marcia's Avatar
Marcia Marcia is offline Searching content of a cell in multiple cells Windows 7 32bit Searching content of a cell in multiple cells Office 2007
Expert
 
Join Date: May 2018
Location: Philippines
Posts: 553
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default

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



=VLOOKUP(A3,sheet2!A:C,3,FALSE)
Reply With Quote
  #3  
Old 03-25-2019, 07:34 AM
Tesla Tesla is offline Searching content of a cell in multiple cells Windows 7 32bit Searching content of a cell in multiple cells Office 2003
Advanced Beginner
Searching content of a cell in multiple cells
 
Join Date: Sep 2018
Posts: 59
Tesla is on a distinguished road
Default

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.
Reply With Quote
  #4  
Old 03-25-2019, 08:13 AM
Marcia's Avatar
Marcia Marcia is offline Searching content of a cell in multiple cells Windows 7 32bit Searching content of a cell in multiple cells Office 2007
Expert
 
Join Date: May 2018
Location: Philippines
Posts: 553
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default

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.
Reply With Quote
  #5  
Old 03-25-2019, 10:54 AM
xor xor is offline Searching content of a cell in multiple cells Windows 10 Searching content of a cell in multiple cells Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,101
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

Maybe like this.
Attached Files
File Type: xlsx Searching_Content.xlsx (11.7 KB, 14 views)
Reply With Quote
  #6  
Old 03-25-2019, 10:14 PM
Tesla Tesla is offline Searching content of a cell in multiple cells Windows 7 32bit Searching content of a cell in multiple cells Office 2003
Advanced Beginner
Searching content of a cell in multiple cells
 
Join Date: Sep 2018
Posts: 59
Tesla is on a distinguished road
Default

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
Reply With Quote
Reply

Thread Tools
Display Modes


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

Other Forums: Access Forums

All times are GMT -7. The time now is 01:36 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft