The reason that won't work is because he needs "*Jordan" and "Jordan*" entries to appear.
If you could post what you have in excel form a simple vlookup using wildcards and helper columns should work.