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!
Bookmarks