I have a spreadsheet with two sheets. Sheet1 has a list of URLs (example: "https://link.com/cp/976980-EHVwytJab73noy4H")
Sheet 2 has two columns. Column1 contains a large string of text that has the URL in it. (example:"Pre-Screened Applicant: t 2014-18286 - Test. Full Time. $10. Mon-Fri 1600-0000 AttachAsLinks: trueAttachAsHtmlFile: trueBidirectional: trueSpoofing: trueAttachment0: 340585_test_117248_Resume.docxDear Sample, Please review the attached resume(s) for the candidate(s) listed below: Test-US-Brookhaven-Sample, Test, & Associates/Jacobson Review this candidate's interview: link.com/cp/976980-EHVwytJab73noy4H Thank you."
Column2 contains a manager name. I want to do a VLOOKUP in Sheet1 to return the name of the manager based on the URL.
I know you can do a VLOOKUP with wildcards and created this search, it keeps returning "#N/A"
It seems like there is something about the characters in the string before the link that break this. Can anyone help me figure this out?