Wednesday, May 1, 2013

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) ))


Sheet 7.

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

following is a solution to the problem