Need help solving a formula string. Please assist

Example

B4 contains the text

Cell C4 says TRUE

Cell D4 needs to return the entire text from B4 if part of the text string (IN) is found in B4 and C4 is TRUE

I have this formula, but don't know how to only make it enter the text in D4 FROM B4 if C4 is TRUE

This is the formula I've been working with

=IF(OR(ISNUMBER(SEARCH("IN",B4)),ISNUMBER(SEARCH("IN",B4))),B4,"Not Used")

Can anyone re-write the formula for me?

Thanks,
Kevin

Fast answers need clear examples. Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results.

Please see attached sample spreadsheet

Column A contains checkboxes that update column C to True or False

Column B is the full data

Column C is the True/False from the checkbox (Column A)

Need Column D, each row, to only copy the name into the respective row cell in Column D if A is Checked, causing Column C to turn to True

Here's the string I've been working with.

=IF(OR(ISNUMBER(SEARCH("IN",B4)),ISNUMBER(SEARCH("IN",B4))),B4,"")

Thanks for the help and support.

Regards
Kevin

Thank you,

=IF(AND(ISNUMBER(SEARCH("IN",B4)),C4=TRUE),B4,"")

Worked great.

Thank you for your help

Originally Posted by Sam Capricci

I think this is the formula you are wanting then... =IF(AND(ISNUMBER(SEARCH("IN",B4)),C4=TRUE),B4,"")

IS there a way to include an error message if A is checked and C is true but D is blank?

Thank you for your help =) Cheers