vlookup to find partial matches

[chris789]

I have two sheets in my workbook and am trying to figure out how to create a vlookup that finds partial matches.

Sheet1 : Column A
Chris
Doug
John

Sheet2 : Column A
s
u

I need to create a vlookup that will highlight the lines in Sheet1 that contain either s or u

Vlookup would create in Sheet1 : Column B
Chris
Doug

but John doesn't match so it would be ignored.

I've used vlookup in the past to locate entire matches but not partial matches so not sure if its possible.

Is there a way to do this?

Thanks,
Chris

[cbatrody]

Hi

Could you post a sample excel file with enough data demonstrating your requirement?