Name Search in Excel

Occasional Contributor
I have say one worksheet (say A) where there are names such as:
1. Aby Gomes
2. Jacob Hunter Streep
3. Gomes Jake Leo
4. Ms Margot Robert
5. Ms Selena Leo
6. Dianne Cobb

Another worksheet (B)
1. Drake Joseph
2. Dianne Celeb
3. Peter Aby Gomes
4. Streep Jacob Hunter
5. Cobb, Dianne
6. Ms Leo
7. Drake Cobb
8. Nill Manderson

Data in my excel files are like this, is there any way I can use a function to find if a certain name in worksheet A exists in worksheet B or not. I need to find a partial match (even if they are not the same person i just need the partial matching names highlighted) also is there any way to find by their calling names like Aby, Jacob, Leo etc?
2 Replies

 

@Mahdia_Akter Hello! You've posted your question in the Tech Community Discussion space, which is intended for discussion around the Tech Community website itself, not product questions. I'm moving your question to the Excel space - please post Excel questions here in the future. 

Sure, i didn't know that. Apologies.