VBA If Vlookup + If Error

[42Nice]

Hello,

My goal is to click a button so the vba macro will apply the following:

1)If found value = Y
If not found value = N
IFERROR = N

In formula the expression would look like:
=IFERROR(IF(VLOOKUP(A2,PLsql!B:F,5,0)<>"","Y","N"),"N")

2) There are 2 worksheets - NewFormat & Plsql.
- The result should appear in column E("NewFormat" worksheet)
- The result should be "draged down" untill the filled value in column A("NewFormat" worksheet)


Let me know if I can explain it better, I would love to get some hints/solution from you guys!