I want to merge two sheets and use the merged data in a new sheet.

Both my sheets contains similar info but there are fields that differ.

I need Column A from one sheet to look in Column D of the other one to see
if that one contains the same info. A simple return like False or True would
be enough for me.

One sheet contains 2500 entries and the other 4500.

I'll filter the results afterwards.

Any help would be appreciated

kubersluiper