If cell has text then go to sheet x and insert [Closed]

Report
-
 Finfool -
Hello,

I need a formula that can insert text on another sheet.

So sheet 1 A1 has text then take that text insert it into Sheet 2 line "to be determined" and add this text with it.

1 reply

=IF('Sheet1'!B16 <> "","Bob "&'Sheet1'!B16,"!")

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!