Hello prschilli, welcome to the board.
So. . . is the only indication of whether or not a customer is "preferred" going to be if their customer id(?) - name(?) is found in column A or B of your sheet "preferred"?
Am I correct in thinking you only want the preferred customers from the "Purchases" sheet to show on the "preferred purchases" sheet if there are/were purchases made?