If you don't mind TRUE/FALSE instead of YES/NO, then put this in C16 and copy down:

=VLOOKUP(A16, SDEDATA_Checking!D:E, 2, 0)=B16