Finding Text contained within Text with If function

**wayneajt1990** · 03-23-2018, 07:08 AM

HI!
trying to use IF ISNUMBER & SEARCH as per attached spreadsheet for pole types, however it keeps returning the false argument even when true?! please help

thanks

**kev_** · 03-23-2018, 07:16 AM

Formula:

Please Login or Register  to view this content.

You had comma which is not required =IF(ISNUMBER(SEARCH("Terminal",A3 , )), "Terminal H Pole", "dafty")

Finding Text contained within Text with If function

LinkBack

Thread Tools

Rate This Thread

Display

Finding Text contained within Text with If function

Re: Finding Text contained within Text with If function

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Add 1 to a number contained in text.

How to round a number off when contained in text

[SOLVED] Looking for a formula that indicates text not contained in a list.

Finding Contained Text within Multi-Faceted Formula

[SOLVED] Return specific text if a different text is contained anywhere in a range of cells

Countif function for instances of text string contained

[SOLVED] RE: Countif function for instances of text string contained

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions