Well, neither of those VLOOKUPs were set up properly. And they looked
to that 2nd column, so even if it found a match, it would return a
blank from your empty column.

But vlookup isn't really what you want anyway. I think muddan's
formula should help. Then you can Sort on column B and easily delete
all the Bad lines. If that is what you are trying to do.