Define symbols. Do you mean stock ticker symbols?

Are both columns the same length? You only need to check the shortest
column. How many rows does the shortest column contain?

Biff

"Manfred" wrote in message
...
I thought I knew how to perform the following simple function, but I must
be
missing something basic.

The problem: I am assembling a spreadsheet consisting of 2 columns
of symbols. The two columns may or may not have matching symbols.

The question: Is there a formula what will search through both columns
and
list symbols that appear in BOTH columns, LISTING these symbols in a
separate third column?

Thank you for any response.