VLook-Up Blank cells in Linked Sheet

[brownt]

Hello All,
I'm trying to find the blank cells in a linked sheet using this string:
=IF(ISERROR(VLOOKUP(D1015, Sheet1!D:D, 2, 0)), "missing variable", VLOOKUP(D2, Sheet2!D:D, 2, 0))
It is sort of working...In sheet 1, I have all usernames in cell 'D'. On sheet 2, I have some usernames in cell 'D'. I'm trying to match these up to show "missing variable', but everyone is showing as missing.
Also, the numbers where the names are located on each sheet is different (as shown in the formula above). Does this make a difference?
Please can someone point me in the right direction? Any assistance would be greatly appreciated.
Thanks and have a wonderful day!
brownt

 

[brownt]

Thanks, jonmon1...I think my eyes are getting tired. Sorry ) but thanks.