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 assume 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.
2007-02-21
04:40:23
·
2 answers
·
asked by
eltel2910
1