Find a cell that contains....

[mrpwagner]

I recently posted a similar request but I think I need to modify this.

I have work book with a list of members. One of the column is the last name of the members.

I have a workbook with a bibliography. One of the columns is a list of authors. [LN1, FN1, LN2, FN2,.......etc] In the bibliography workbook I will need to see if each individual author groups contains a match to one (or more) last names in the member table.

Thanks in advance.

 

[cyrilbrd]

Hi, have you tried match? =MATCH(individual author, list of author, exact match)