I have values in column B and C. All except 4 from column B should have a matching pair in one of the rows from column C.

I tried to use the code =FILTER(B:B, ISNA(MATCH(B:B, C:C, 0))) but that only shows me 7 matching values. Any idea why it's not matching the 75 of 79 values?

CodePudding user response：

Use this formula

=BYROW(B1:B, LAMBDA(x, IF(x="",,IFNA(INDEX( C1:C, MATCH(x, C1:C, 0), 1),"Missing"))))

Find missing

=IFERROR(FILTER(B:B, ISERROR(MATCH(B:B,C:C  , FALSE))), "No match")