I would like to look for a string in sheet 1 column A, compare to values to sheet 2 column A. If the value in sheet 2 column A matches any part of the text in sheet 1 column A, replace it with the value from sheet 2 column B.
Here is example data. I'm not sure how to write a formula to do this. Any thoughts?
Sheet1:
Column A
\\something\something,ABC\FJones,ReadAndExecute, Synchronize
\\something\something,ABC\RJones,ReadAndExecute, Synchronize
\\something\something,ABC\ASmith,ReadAndExecute, Synchronize
Sheet2:
Column A
ABC\FJONES
ABC\RJones
ABC\ASmith
Column B
XYZ\jonesfre
XYZ\jonesrob
XYZ\smithann
Expected result:
\\something\something,XYZ\jonesfre,ReadAndExecute, Synchronize
\\something\something,XYZ\jonesrob,ReadAndExecute, Synchronize
\\something\something,XYZ\smithann,ReadAndExecute, Synchronize
Bookmarks