IF value in column matches another column, then insert text

[Rick187]

Hi,

Is there a formula that will insert specific text in a cell if any of the cells from column A are equal to the names in Column B?

For example

Column A contains

123
456
789

Column B contains:

471
871
951
123
456

the last 2 cells in column B (123, and 456) are also in Column A somewhere.

Column C next to the cell from Column B that says 123 will display "matching", and against 456 will also display "matching" but the rest of the cells in column C won't display anything.

Is this possible to do with a formula please?

Any help would be appreciated.

Thanks

 

[DanteAmor]

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Cell[/TD]
[TD]Formula[/TD]
[/TR]
[TR]
[TD]C2[/TD]
[TD]=IFERROR(IF(MATCH(B2,$A$2:$A$20,0)>0, "matching",""),"")[/TD]
[/TR]
</tbody>[/TABLE]


Copy the formula down.

 

[jtakw]

Hi,

You can use COUNTIF.

Change/adjust cell references/range as needed, formula copied down.

Book1
	A	B	C
1	123	471
2	456	871
3	789	951
4		123	matching
5		456	matching
Sheet542

Cell Formulas
Range	Formula
C1	=IF(COUNTIF(A$1:A$3,B1),"matching","")