I need to put "Yes" into N2 if my account in D2 is among accounts from sheet
BM cells ranging from D2 thru D500. This formula works:
=IF(COUNTIF(BM!$D$2:$D$500,D2)0,"Yes","")
Now, I need to expand this formula. Once the D cell from BM sheet matched
with N, I need to check that the corresponding G in BM sheet is blank. If
this is the case then I should put "Yes" in N. How can this be done?