Finding words from a list in Excel?

I have a list of 30000 names in the form johnsmith and I know if I wanted to flag all the cells with "johnsmith" I could write: =(VLOOKUP(A1,names,1,FALSE),A1,1), where A1 is the what I'm testing and names is the table of names that I want to key in on. But what if I wanted all names with smith? I ume I need something like: FIND(VLOOKUP(A1,test,1,FALSE),A1,1), but it won't work. *Note the names are in the form johnsmith, so with no space I have nothing to parse on, so I will need some kind of find function.