If Cell contains some text from another Cell, then return "True".

**PatricMiller** · 02-12-2021, 11:16 AM

If A1 contains any text from B1, then return "True" in C1.

For Example.
A1 = 123_A
B1 = 123

A1 contains the "123" from B1, so it should return "True" in C1.

I just need to know the formula to do this. I've attached an example sheet.

**Glenn Kennedy** · 02-12-2021, 11:19 AM

Hi.

=ISNUMBER(SEARCH(B1,A1))

copied down.

**Limor_OP** · 02-12-2021, 11:21 AM

Hi
Try this in C1:
=IFERROR(IF(SEARCH(B1,A1)>0,TRUE),FALSE)

**PatricMiller** · 02-12-2021, 11:32 AM

Thanks, this gets it done.

**Glenn Kennedy** · 02-12-2021, 11:32 AM

You're welcome.

It would be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.

Finally, if that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

**PatricMiller** · 02-12-2021, 11:39 AM

Thank you so much, this gets the job done!

If Cell contains some text from another Cell, then return "True".

LinkBack

Thread Tools

Rate This Thread

Display

If Cell contains some text from another Cell, then return "True".

Re: If Cell contains some text from another Cell, then return "True".

Re: If Cell contains some text from another Cell, then return "True".

Re: If Cell contains some text from another Cell, then return "True".

Re: If Cell contains some text from another Cell, then return "True".

Re: If Cell contains some text from another Cell, then return "True".

Thread Information

Users Browsing this Thread

Similar Threads

Formula for "true" or "false" based on whether or not a row has a color filled cell

if cell A value matches a value in Range B, return "TRUE" in cell C

[SOLVED] If statement that return "True" If a cell's date is the last day of a year.

[SOLVED] =IF(M4>=21,--TRUE(),"0") - need to return 0 from blank cell

Return "True" if a cell within a row of cells contains a certain text string

IF logic_test=true, "how do I input text from the same table into another cell?"

If "text" exist within "cell" then TRUE

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions