I have a sheet where I need to make a note next in one column based on the contents of another.
Scenerio.
Column T contains a short list of items to be matched against the contents of Column B. If Column B contains one or more instances of any tem in Column T, then the appropriate row or rows in Column S should be marked with the words Unreachable.
I need a VLookup solution that won't require any VBA.