Compare 2 columns & fill in 3rd

  • Thread starter Thread starter Doug Little
  • Start date Start date
D

Doug Little

I have a spreadsheet with multiple columns. I want to see
if an item in column A is in anywhere in column C. If it
is, I want to add the info from column A to column B.

Please advise, oh great Excel gurus.

Thanks much

Doug
 
Hi

If I understand you correctly, try this in B2:

=IF(COUNTIF(C:C,A2)>1,A2,"")
You can then fill this down your range
 
Hi Doug
enter the following formula in B1:
=IF(COUNTIF(C:C,A1)>1,A1,"")
and copy this down
 
Back
Top