Results 1 to 3 of 3

Thread: Searching for a text value (cell match) within text in multiple cells on another tab.

  1. #1

    Searching for a text value (cell match) within text in multiple cells on another tab.



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

    I hope this is an easy question for someone out there....

    I have generated a function as below, that I can make work correctly when it only interrogates a single cell.

    =IF(SUM(IFERROR(FIND(B3,'Tab2'!$H$4),0))>0,"FOUND","NO")

    when I expand it to use a cell range (like below), it stops working.

    =IF(SUM(IFERROR(FIND(B3,'Tab2'!$H$4:$K$625),0))>0, "FOUND", "NO")

    What am I doing wrong?

    Hoping there is a Guru out there who can advise.

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,464
    Articles
    0
    Excel Version
    Excel 2016
    How about?

    =IF(COUNTIF('Tab2'!$H$4:$K$625,"*"&B3&"*")>0, "FOUND", "NO")


  3. #3
    Thank you so much NBVC, that works perfectly !!

Posting Permissions

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