Compare 2 columns & fill in 3rd

[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

 

[Andy B]

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

 

[Frank Kabel]

Hi Doug
enter the following formula in B1:
=IF(COUNTIF(C:C,A1)>1,A1,"")
and copy this down