Excel advanced search / cross-matching names

I need a little help: I have to cross match Database A user names(firstname lastname) with Database B where there are some extra characters and the order is last name firstname), so the normal vlookup does not find exact match. I tried the following: I used text to column from the Database A, to have two separate column, then I tried to crossmatch the names from Database B
=IF(IF(ISNUMBER(SEARCH(A1,F:F)),ISNUMBER(SEARCH(B1,F:F))),"yes","no")
This show Yes result when the name is in the same line
A1 Tom
B1 John
F1 John dr tom -
The results is true(yes), but in case:
A1 Tom
B1 JoHn
C2 John dr tom -
the result are false(No) - But I need yes
So I need to find the duplicated items. Can someone help me out how to correctly find what I am looking for?


Here is an example picture:

cross posted without links:
https://www.mrexcel.com/forum/excel-questions/1071584-search-function-question-vlookup-ifnumber.html

JulaTheOne, for your information, you should always provide links to your cross posts.
This is a requirement, not just a request.
If you have cross posted at other places, please add links to them too.
Why? Have a read of http://www.excelguru.ca/content.php?184