Is there a formula that will find items even though they are not exact. I tried using a variation of VLookup but failed miserably.
Lets say I have these on Sheet 1
SECURE TRUST B1016003 BS BMCE2
And these on Sheet2
SECURE TRUST B1016003
272637 27FEB600304 BS BMFSP (2)
I am sure there is a way but only an expert will know the answer to that.