Hi,

Try this array formula (Ctrl+Shift+Enter)

=if(OR(EXACT(A3,Names1!$A$3:A5)),A3,"")

where A3 is from the first column and Names1!$A$3:A5 is from the second column

Regards,

Ashish Mathur

"ruby2sdy" wrote:

Hi

Can anyone please help me compare two columns of text to come up with a
list of items that are in both lists

Many thanks