I have two sheets in Google sheetsSheets. In one I have two columns with values I need to find in two columns of the second one and return number of matches for each row in the first one.
=Iferror(INDEX ( Leads!$C$2:C$1000, ( MATCH ( $A2 & $B2,Leads!$A$2:$A$1000 & Leads!$B$2:$B$100, 0 ))),0)
I've been using this function and then assigning it 11
or 00
values with IF function, but it works only for a range without more than 1one match. I have no idea how
How to do it when there are more matches
Please help.?