Hi,

I have a list of titles I need to find in another list.

I know my original list isn't shwon the exact same way but need to find it
none the less. E.g. in the original list it is shown as 'Eye', but in the
list I am looking for it in it is shown as 'Eye, The'.

A Vlookup won't work because they aren't the same. Is there a formula I can
use to locate my target easily? I have several hundred I need to find. I also
need to return a value to the right of the target column.

Thanks
Rick