So I'm trying to use

=IFERROR(VLOOKUP(D2,'Sheet2l'!$A$2:$M$2467,6,FALSE)>P2,VLOOKUP(D2,'Sheet2'!$A$2:$M$2467,6,FALSE))

I tried using it with IF instead of IFERROR as well and it didn't work

using

=IF(VLOOKUP(D2,'Sheet2'!$A$2:$M$2467,6,FALSE)<=P2,VLOOKUP(D2,'Sheet2'!$A$2:$M$2467,6,FALSE),"")


which produces 1/0/1900 for anything that has a blank in Sheet2

Any way to fix the 1/0/1900's and the #N/A's that come with the second formula?