• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. J

    Search Text in Two Columns and Return a Value

    Ah, beginning to get the picture now. I'll have to search some more to find out how exactly does the FIND() and SEARCH() functions differ and why do they both work in this case. Thanks so much Narayan =)
  2. J

    Search Text in Two Columns and Return a Value

    Wow, works like a charm! Could I trouble you for a brief explanation on the breakdown of the formula? Edit: After some additional searching and trials, I found an alternative that works as well =IF(ISNUMBER(SEARCH($K$1,D2)),$K$1,IF(ISNUMBER(SEARCH($L$1,B2)),$L$1,""))
  3. J

    Search Text in Two Columns and Return a Value

    Hi Narayan! 1. Yes, just as you described it. 2. Ditto. 3. Columns K and L will not contain anything. I only used Cells K1 and L1 to contain my search string. Appreciate your reply! =)
  4. J

    Search Text in Two Columns and Return a Value

    Hello all, I'm using Excel 2007. Data set: --Column B----Column C----Column D----Column E---- 1-LAMP Q----*value*----This is a fish----50,000---- 2-*blank*----*value*----(K) This is a fish 2----250---- 3-etc J1=40000, J2=50000, K1=(K), L1=Q Formulas: Column B...
Back
Top