research data between 2 sheets
 

Hi,

I have a workbook in which i have 2 sheets (SheetA and SheetB)

For each row (data in a column D) of SheetB, i would like to know if
such data exists in SheetA (column E).

if yes, i go to next row data of SheetB
if no, i add a new row (at the end of SheetA rows) and copy some data
from SheetB to SheetA.

I already did in the past but i forgot the function :(
i think i was using VLOOKUP and IF together, but i'm not sure.

thanks a lot,

Alain