Thread: Searching content of a cell in multiple cells
View Single Post
 
Old 03-25-2019, 06:03 AM
Marcia's Avatar
Marcia Marcia is offline Windows 7 32bit Office 2007
Expert
  
Join Date: May 2018
Location: Philippines
Posts: 551
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