Pull from Row from one Sheet to Another Array Formula ?

[jphilipson]

Hey Guys, I have used an array formula before but for some reason I cant get this to work. On the sheet task log there are Row that in the Column G have the Task "Pipe" or P&P. On the sheet Piped files for Review I am trying to pull over the entire row without any blank rows in between. Any help would be greatly appreciated, been at this for hours using old spreadsheets to try and get the answer.

[FDibbins]

This will pull all entries that have Pipe in col G (note that you have a trailing space after Pipe)...
=IFERROR(INDEX('Task Log'!A:A,SMALL(IF('Task Log'!$G$2:$G$76="Pipe ",ROW('Task Log'!$A$2:$A$76)),ROWS($A$1:A1))),"")
**Array formulas are not entered in the same way as 'standard' formulas. Instead of pressing just ENTER, you first hold down CTRL and SHIFT, and only then press ENTER. If you've done it correctly, you'll notice Excel puts curly brackets {} around the formula (though do not attempt to manually insert these yourself).

[Bo_Ry]

Please try at
A2:Axx
=IFERROR(SMALL(IF(ISNUMBER(SEARCH("p?p*",'Task Log'!$G$2:$G$999)),ROW('Task Log'!$G$2:$G$999)),ROWS(A$2:A2)),"")
Ctrl+Shift+Enter

B2:Kxx
=IF($A2="","",INDEX('Task Log'!A$1:A$999,$A2))

Custom format to display as need