Results 1 to 5 of 5

Finding / searching multiple values in one cell

Threaded View

  1. #1
    Registered User
    Join Date
    08-09-2010
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    45

    Finding / searching multiple values in one cell

    Hey guys,

    For the purpose of this question I'm going to use animals as an example. I have a list of animals (Range: D2:D5) and I want to see if any of the animals in that list appear in a specific cell (Range: B2). The cell is formatted the following way:

    Animal name / animal name / animal name etc

    If an animal is found in the above cell then I would like to return a 1 next to it.

    I've tried to do this using the following array formula, but am having no luck:

    {=IF(FIND(D2:D5,B2,1)>1,1,0)}

    Could anyone please help me out as to where I'm going wrong? I have attached a sample sheet with how my results would look if it will help you get the picture.

    Thanks!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1