Not sure what formula to use...

[ladyday]

I am seeking a formula that will allow me look into a column and return similiar data. The problem is my data is arriving from several different sources, therefore, the data is not in the same format, it is over 4K rows and it is coming in on a daily basis and I have no time to scrub it. I am dealing with tlitles, so an example would be the title A Visit from Grandma can appear in the list I am looking up as Visit from Grandma, A or Visit from Grandma. When peforming a vlookup and using an exact match (false) the formula will not find the titles if the punction or verbiage arrangement is not exact. I need a formula to find the title regardless of the arrangment. I am assuming it would be an INDEX array but I don't really understand how to use the function.

So this is what I am seeking below.
[TABLE="class: cms_table, width: 640"]
<tbody>[TR]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="class: cms_table_grid, width: 700, align: left"]
<tbody>[TR]
[TD]
[/TD]
[TD]Column Q[/TD]
[TD]Column E[/TD]
[TD]Column T[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]=T1,look in Column E and return results with the same verbiage[/TD]
[TD]The ABC Book[/TD]
[TD]Visit from Grandma, A[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]
[/TD]
[TD]Numbers Counting[/TD]
[TD]Book, ABC The[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]
[/TD]
[TD]A Visit From Grandma[/TD]
[TD]Counting Numbers[/TD]
[/TR]
</tbody>[/TABLE]

 

[Aladin Akyurek]

See: http://www.mrexcel.com/forum/excel-questions/195635-fuzzy-matching-new-version-plus-explanation.html

 

[ladyday]

Thank you. The match formula provides the number of possible results. I don't have the bandwith to research results for over 4,300 rows of data. Is there another formula I can use? Perhaps an INDEX formula that can help me out? Even if it narrows my results down to a hundred rows I may need research instead 4,000...