Hi Guys,

I'm practically new to excel formulas, I just want to make my life easier and found out that excel is the one i'm looking for, so here goes.

I have a certain number of companies in column A, sheet 1 that i would like to find in column A, sheet 2, here's the hard part. i would like to compare let's say the first 5 letters of every company rather than checking the exact text in the cell. is this doable? thanks

i have attached a sample

sample.xlsx