Compare/search Excel Sheet

Question

Hi, I have to Excel tables. They are sorted after one attribute. Now I want to compare these tables. The problem is, my tables don't have the same values.

e.g. Table 1 1 2 3 4 5 7 9

table 2 1 3 4 5 6 7 9

if I try to compare these fields hardcoded (IF(A1=B1;x;y)) i have some missing rows as soon as I get to 3 in Table2. So how am I able to search the table for this number and compare its corresponding row to the other? Please no VB-skript ;)

Thanks for your help