Hope this is the right forum :)

I have a spreadsheet with a long list of names that I have to go through and pick the employees that are mine. What I'm trying to do is simplify this by creating a find formula(or multiple) that will automatically populate the column where I indicate they are mine.

An example. I have Column A that is where I put my name to indicate the employee belongs to me. I need to populate this with toy4x4 if they are my employee.

Column B contains the employee first and last names and there is no rhyme or reason to the format of their name in this column.

I can do a =find("Smith",b1) and it returns a 7 which is the starting point in the string for that last name.

Problem is I have 17 employees. So I need to find "Smith", "Jones", "Brown", "White", etc


I have to do this monthly and in about 15 spreasheets so I'm looking for an easy cut and paste method.

Thanks in advance!!