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

2 comments:

  1. =ArrayFormula(iferror(if(search(" "&B11:B24&" "," "&J7&" "),B11:B24,)))

    This formula worked for me, thanks a lot!

    ReplyDelete
  2. You Are Very Welcome vf1000 -- Now Let Us Keep Googling.

    Make It A Great One
    Cheers!
    Yogi
    Cloud Computing -- Google Docs Way
    yogi--anand-consulting.blogspot.com

    ReplyDelete