Hi All,

I have workbook with 10k row.

I need to match with these cell with another column and get result.

For Eg.,
Sheet 1
Col A Col B
Bristol B Cheddar
Gloucester The Road

sheet2
Col A
Bristol - If Cell value match with sheet1 col A data get me col B
data
in sheet2.

I need to match all possible way

If the value is
"Bristol" - Its match
"Bristol B" - its match
"Brist" - its match
"tol B" - its match

I need all the types matches in vba, Pls guide me to get the output.