I used this formula to look for matches between 2 columns:
<code>
=ISNUMBER(MATCH(F2,List1,0))
</code>
But I'm having trouble inserting cells next to the non matching column data,
because the data across columns don't line up and dont have the same number of matching rows...
any ideas