I have 2 columns on sheets(1), E and F.
I want to populate all of the cells of these columns by searching the value in column D of sheets(1) on sheets(2) and get the 3rd and 4th values.
The target cells should have formula, not the values only.
I cannot figure out how to do it by vba code, would appreciate some help.

Thanks