Thread: how do i compare two text columns
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Shane Devenshire[_2_] Shane Devenshire[_2_] is offline
external usenet poster
  
Posts: 3,346
Default 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
Reply With QuoteReply With Quote