Finding Words with in Excel

[ravaz]

I have a sheet with a list of name example Aaron Tumbler, chris Turner etc

Have got another sheet in which the names are mentioned as Tumbler Aaron, Turner Chris...

Need help to check whether name mentioned in sheet 2 is there in sheet 1

Thanks for your help

 

[Kerryx]

Can you reverse the text in one list so you are looking at like for like
=RIGHT(a1,LEN(A1)-FIND(" ",A1))&" "&LEFT(A1,FIND(" ",A1)-1)
Change A1 to the cell containing the name you would like to reverse around or put it into formula in lookup or match

 

[jtakw]

Hi,

You can do this:

Book1
	A	B	C	D
1				On Sheet 1?
2	Aaron Tumbler		Jill Doe	Yes
3	chris Turner		Tumbler Aaron	Yes
4	Jane Doe		Turner Chris	Yes
5	Jill Doe		John Doe	No
Sheet519

Cell Formulas
Range	Formula
D2	=IF(ISNUMBER(LOOKUP(2,1/SEARCH(C2,A$2:A$5&" "&A$2:A$5))),"Yes","No")

Change adjust Cell references/Range, add Sheet Names, as needed, formula copied down.