Excel, If 1st cell is empty, I want data from 2nd cell to copy into 3rd cell

If 1st cell is empty, I want data from 2nd cell to copy into 3rd cell

Author	Message
Eric #1 / 2	If 1st cell is empty, I want data from 2nd cell to copy into 3rd cell 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.
Mon, 21 Mar 2005 21:34:39 GMT

Arvi Laanemet #2 / 2	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.
Mon, 21 Mar 2005 21:51:23 GMT

Page 1 of 1

[ 2 post ]