1

You want a fast, effienct way to find matches between two sets of order numbers. Let's assume that one set of order numbers are in Sheet1 and this sheet is to be compared to those on Sheet2, and that row 1 in each sheet contains headers. Enter this formula in Sheet1, Cell B2: =arrayformula(iferror(match(A2:A,Sheet2!$A$2:$A,0),"")) This tests for a ...


Only top voted, non community-wiki answers of a minimum length are eligible