Sheet metal journeymen and apprentice job
Try =IF (And (Sheet1.A2="x";Sheet1.A5="n");Sheet1.A3;"") . Spreadsheets normally do not copy anything elsewhere, whether conditionally or otherwise. A cell may contain a formula and the evaluator will poll the contents (values) of the referenced cells or ranges and evaluate a result from them. 2 : Find not see cell formatting but only data, if this is important for you see the xlCellTypeLastCell and UsedRange section of this page to find the last row or column. 3 : If you use merged cells (Please do not use merged cells) maybe you get unexpected results.