How to scan two areas with text

G

George

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
 
A

Alojz

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