yogi_From A Column Of Entries Pull The Exact String As Specified

                                          Google Spreadsheet   Post  #1164
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   May 01, 2013
user vif1000  (http://productforums.google.com/forum/?zx=crpyw0e3sdva#!category-topic/docs/spreadsheets/3cjBewdi2SY)
=arrayformula( if( iferror(search($B9:$B22;J5)); $B9:$B22; iferror(1/0) ))
Trouble with formula from H.:  =arrayformula( if( iferror(search($B9:$B22;J5)); $B9:$B22; iferror(1/0) ))

Please look into this sheet: https://docs.google.com/spreadsheet/ccc?key=0Ai29kwV35K0SdDAtRVRWNUg2VWw5Q0lpSVJUU0ZzeGc&usp=sharing

Sheet 7.

The result of formula can only give on uniqe result, but now it gives 2.,,.

----------------------------------------------------------------------------------------------------------------

following is a solution to the problem