
If 1st cell is empty, I want data from 2nd cell to copy into 3rd cell
Hi
To copy or to display? When last then:
=IF('Job Data'!B17="",'Job Data'!B25,'Job Data'!B17)
Arvi Laanemets
Quote:
> My Work Book contains work sheets "Job Data" & "Log
> Sheet". "Job Data" contains various job related numbers,
> names, and addresses. I'd like the data from cell B17 to
> copy to "Log Sheet" cell F2. But if "Job Data" cell B17
> is empty, then I'd like "Job Sheet" cell B25 to copy
> to "Log Sheet" cell F2 instead.