How to scan two areas with text
 

How to scan 2 areas with text? if some of the cells are with the same text to
show third cell.

For example: if some cell in area A3:A20 is the same with some cell in area
B3:B20, show C5

Thants in advance,

George

How to scan two areas with text
 

=if(sum(countif(a3:a20,b3:b20))0,c5,"no matches");
hit ctrl+shift+enter (array formula)
HTH

"George" wrote:

How to scan 2 areas with text? if some of the cells are with the same text to
show third cell.

For example: if some cell in area A3:A20 is the same with some cell in area
B3:B20, show C5

Thants in advance,

George