Hi All,

I'm trying to create a master spreadsheet using data from many other spreadsheets. These other spreadsheets all refer to the same things, but they are all over the place in terms of standardized nomenclature. For example, for the name "Johnson", I'll see everything from "Johnson - North Carolina", to "Jim Johnson", to "John son", to "Jim". I'm trying to wrangle all of these various non-standard names (that refer to the same person) into a standard name. I've used embedded IF's before like: =if(sum(countif(A1,{"*John*","*Jim*"}))>0,"Johnson",....move on to the next option if false. That works when I have less that 7 different categories I have to match, but in this case, I need to match 32! Any thoughts?

Thanks!