Shg,
I am not an Excel expert by any means, but here's what I've tried.

=IF(OR(ISBLANK(A1),ISBLANK(C1)),"",M10),(OR(ISBLANK(A1),ISBLANK(D1)),"",M10),(OR(ISBLANK(B1),ISBLANK(C1)),"",M10),(OR(ISBLANK(B1),ISBLANK(D1)),"",M10),

Basically there are 4 combinations that I'm trying to test. I'm using M10 to represent the record that I wish to copy to another spreadsheet. Below is what the spreadsheet looks like; it got disoriented in my original posting.


--------A -------B ------C ------D
R1 ---234A--- N333---4T41 ---7657
R2 ---11C2 ---321 ----3T27
R3 -----------L954 -------------989
R4 -56D1-----297-1-----------
R5 --------------------87E3 ----P199
R6- D992-------------------------
R7 -Z222------------------------3391

Thanks!