write permanently to another sheet from a cell with formulated lookup value

[ajish002]

Thanks in advance
but the value is being pasted in the BL column 2nd row, if the vlookup value is given "2"
the value need to be pasted in BLth column,but not in 2nd row if the vlookup value is "2",
but corresponding lookup value is in the A column and if lookup value "2" is in A8 then D32 should be written in BL8