Results 1 to 3 of 3

Thread: Formula Request: Search Between Columns

  1. #1

    Formula Request: Search Between Columns



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I am looking for a formula to accomplish the following:

    The search needs to search column 3 for the numbers in column "Included" and "Excluded"
    The columns have more than 10k lines
    The search is anywhere in column 3

    Thank you in advance for any help.
    Attached Files Attached Files

  2. #2
    Try

    =IF(COUNTIF(C:C,"*"&A6&"*"),"Included",IF(COUNTIF(C:C,"*"&B6&"*"),"Excluded","Not Found"))

  3. #3

    Formula Request: Search Between Columns

    Quote Originally Posted by Bob Phillips View Post
    Try

    =IF(COUNTIF(C:C,"*"&A6&"*"),"Included",IF(COUNTIF(C:C,"*"&B6&"*"),"Excluded","Not Found"))

    Thank you so very much.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •