Link to home
Start Free TrialLog in
Avatar of Ted Penner
Ted PennerFlag for United States of America

asked on

VLookup without vba

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.  

Assistance is greatly appreciated.
Sample.xlsx
SOLUTION
Avatar of Professor J
Professor J

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Ted Penner

ASKER

All great solutions.  Thank you all.