how do i compare two text columns
 

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

how do i compare two text columns
 

Hi,

Try

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


--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"sflanegin" wrote:

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