I would like to know a formula that allows a cell to be copied if the cell from another sheet has a value or text and if there's a cell next to it that also has a value or text. For example:
If A1 in sheet 2 AND 12 have a text or value then copy A1 from Sheet 2 to A1 from Sheet1.
I would also want one that if there's a value from A1 in sheet 2 but nothing on B1 then to copy cell A1 from sheet 2 to C1 from sheet 1. I've attached an excel file with an example.
It looks complicated so thank you for any help given.