+ 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
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166
    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)

Similar Threads

  1. Deleting rows by searching a specific word or empty cell.
    By erickmcburger in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 07-31-2015, 07:42 AM
  2. Replies: 9
    Last Post: 09-13-2013, 10:16 PM
  3. Replies: 0
    Last Post: 08-07-2013, 09:50 AM
  4. [SOLVED] Simple IF formua for searching for a word in a cell
    By Virtuallynne in forum Excel General
    Replies: 5
    Last Post: 05-10-2012, 08:01 AM
  5. Autosum column by searching through row 1 for the word total in first cell of the col
    By daillest319 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 02-21-2012, 03:18 PM
  6. Searching for a certain word within a cell...
    By smithan04 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-16-2011, 03:47 PM
  7. [SOLVED] searching a cell for a contained text word
    By Doug K in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 06-20-2005, 05:05 PM

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