Dear all,

I have in :
- column A, a list of items/jobs :

Batching plant TT1 Eagle Tana Tran
1 unit MSO4500
Batching system - MHw industrial
Dismantling plant - p30/09/03 stanwell - spo tr122919
Dismantling plant - p30/09/03 stanwell - inv no : 03550
1 unit Gen set S25
1 unit batching plant
1 unit Tanaka indicator
1 unit plant fabrication
Add mhw industrial automation
1 turbo gp (or-6904) for wheel loader
Safety platform, water meter stand, piping, crusher run
Add sd mhw industrial auto s/b
Overhaul wheel loader 938f
Alkon batching system
Alkon batching system
Mhw's computer control system

- column B, the lookup value , say, 'Batching'

I would want in column C, the lookup result that should return all
incidence of the word Batching appearing in Column A i.e :

-column C, result should show :

Batching plant TT1 Eagle Tana Tran
Batching system - MHw industrial
1 unit batching plant
Alkon batching system
Alkon batching system

I have used this formula in C5,

=INDEX($A$5:$A$36,(MATCH(FALSE,ISERROR(SEARCH("*"& B5&"*",$A$5:$A$36)),
0)))

entered as array (Ctrl+Shift+Enter) and manage to return the first
found result 'Batching plant TT1 Eagle Tana Tran' but were unable to
find all the rest of the intended results, preferably listed in
separate rows.

Any suggestion or help on this is greatly appreciated.

Thanks heaps ! Everyone.
SauQ