I typed in "Compare" in the help section under Indexed and found a formula
using OR and EXACT together. Check it out and see what you get.

"Dr. Darrell" wrote:

I have a list of 1,000 Document Titles in Column A and I have a list of 1,200
Document Titles in Column B.

I would like to compare the tiltes in Column A to those in Column B. Ideally
all 1,000 titles from Column A should be in Column B as well.

Is there a function in Excel to allow me to identify all the titles in
Column B that are equal to the Titles in Column A?