I need a formula that will match 2 columns of data. The numbers I want to match are in different columns and in different rows. What formula would find the matches in both arrays and put a 1 next to the ones that match. see example spreadsheet attached.

Attached Files

TEST MATCH.xlsm (9.6 KB, 11 views)

Hi

Use COUNTIF() and just count the value of a cell within a column:
B3 =COUNTIF($D$3:$D$31,A3)
E3 =COUNTIF($A$3:$A$31,D3)
Copy the formulas to the end of your list. It will return 0, if there's no match.

You are using a text-format for numbers! I wonder why. Be aware that the above formulas if looking for a text won't find a match in case the same value exists as number (and viceversa). It will return 0.