Comparing and matching data of two columns not of the same size (countif?)

  • Thread starter Thread starter Londonderry
  • Start date Start date
L

Londonderry

I have two spreadsheets. One sheet has around 1060 rows, the other ha
18000 or so.

In column M of sheet 1, i need to find out which strings of number
match up with those also in sheet 2 column B.

I was thinking the best way to do this would be a countif statement
but I have only used that on single columns before. How do you do
countif with multiple columns
 
Hi
enter the following in N1
=IF(COUNTIF('sheet2'!$B:$B,M1)>0,"Match","No match")
and copy down
 
Back
Top