How to scan two areas with text

  • Thread starter Thread starter George
  • Start date Start date
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
 
=if(sum(countif(a3:a20,b3:b20))>0,c5,"no matches");
hit ctrl+shift+enter (array formula)
HTH
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to synchronize all cell values? 1
Print Area to include text box 10
Excel EXCEL - Set non-continuous PrintArea via Function / Name 0
Set non-continuous PrintArea via Function / Name 0
Altered pasting functionality 3
Last Modified By in a cell by user 3
Sum number range ignoring numbers formatted as text 0
Combined IF Statement Question 2

Back
Top