how do i compare two text columns

[sflanegin]

Hi,

I have a workbook with two email columns. I want a function that checks if
the email in column B matches the email in Column A to return the result
(email) in Column C at the same row level it found it in Column A

 

[Shane Devenshire]

Hi,

Try

=IF(COUNTIF(B$1:B$9,A1),A1,"")