I Then logic help

R

robnet

Ok. I would think this simple but can't figure it out..
If value cell 'A1" = True
then paset contents of cell from different sheet in same workbook.


=IF(J10,'4. Environment IP Addresses'!B6," ")

The above value is true, but I recieve a #VALUE! error.

Any help is appreciated. Thanks!
 
P

PCLIVE

I would look at cell J10. Chances are that it is not an actual TRUE value.
Try typing the number one in J10 and press enter.

HTH,
Paul
 
R

robnet

Thanks. You were right. The problem now is the contents of the source cell is
multiple lines of text and the formula does not paste the source in the same
manner, which is what i need.

Any ideas?

Example:

10.10.10.10
20.20.20.20
30.30.30.30

result:
10.10.10.10|20.20.20.20|30.30.30.30
 
B

bj

is your receiving cell formatted for wrap text?

robnet said:
Thanks. You were right. The problem now is the contents of the source cell is
multiple lines of text and the formula does not paste the source in the same
manner, which is what i need.

Any ideas?

Example:

10.10.10.10
20.20.20.20
30.30.30.30

result:
10.10.10.10|20.20.20.20|30.30.30.30
Click to expand...
 
R

robnet

Sometimes it is the simplest things! Thank you.

Anyone know if it is possible to concatenate a column of values with empty
cells between? I am erroring out on it.
 
Top