Forum Discussion
Formula if a cell contains a certain text then return that text in a different cell, otherwise move
Hi I need to create a formula that will copy the text from a cell in a different sheet if it contains the text "7X1", otherwise move to the cell below and if that one contains "7X1" copy that one, o...
Not clear what exactly is required. One more variant for
is
=IFERROR(INDEX($B$2:$B$8,AGGREGATE(15,6,1/ISNUMBER(SEARCH("7X1",$B$2:$B$8))*(ROW($B$2:$B$8)-ROW($B$1)),ROW()-ROW($B$1))),"")