+ Reply to Thread
Results 1 to 2 of 2

Searching for a cell that contains a particular word formula HEEEELP!!

  1. #1
    Registered User
    Join Date
    06-23-2016
    Location
    Cork, Ireland
    MS-Off Ver
    2010
    Posts
    0

    Searching for a cell that contains a particular word formula HEEEELP!!

    Hi,
    Problem:
    I am looking to change a formula I have created so that it searches for the phrase "*from Production*" within a column. The problem I am encountering is that I would like to search for this phrase within another formula and it does not seem to work.
    Background:
    Current formula returns a particular cell in 'column A', finds the (last) occurrence if is equal to 'B244' and if 'column C' equals "Toolroom".

    =INDEX($A:$A,LARGE(IF($B:$B=B244,IF($C:$C="Toolroom",ROW($A:$A),""),""),1))

    I would simply like to add another if statement that returns the cell in 'column A' if 'column AB' CONTAINS the phrase "*from Production*''

    I am trying to use the IF(ISNUMBER(SEARCH( in the middle of this but cannot seem to get it to work. This is what I would envisage the formula to look like


    =INDEX($A:$A,LARGE(IF($B:$B=B244,IF($C:$C="Toolroom",IF(ISNUMBER(SEARCH("*from Production*",$AB:$AB,ROW($A:$A),""),""),1))

    Can anyone help me pleeeeease!

  2. #2
    Administrator arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,145
    Hello Eamon_Guiry,

    Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

+ Reply to Thread

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