Results 1 to 8 of 8

Nested SEARCH or FIND formula query

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-17-2009
    Location
    West Midlands
    MS-Off Ver
    Excel 2016
    Posts
    213

    Nested SEARCH or FIND formula query

    Morning all

    Could anyone help me with a formula problem? I have a column (column C) of products that are alphanumeric. I'd like to put a formula in column B that looks up whether the value in column C contains "240", "230" OR "350" - not all of them but one or the other.

    I have used the formula below, but is there a way I can nest it to search for the other two values?

    =IF(ISERROR(SEARCH("240",C5)),"No","Yes")

    Any help would be greatly appreciated.

    Steve
    Last edited by SAsplin; 07-15-2011 at 06:10 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1