Change the validation type to custom and use

=AND(ISNUMBER(MATCH(Me, CrewName, 0)), COUNTIF(D1:D10, Me) + COUNTIF(J1:J10, Me) = 1)

... Where Me is the address of the active cell when you enter the formula.