Results 1 to 4 of 4

If one cell equals a range of cells, return with true or false

Threaded View

  1. #1
    Forum Contributor
    Join Date
    05-29-2009
    Location
    sheffield
    MS-Off Ver
    Office 365
    Posts
    215

    If one cell equals a range of cells, return with true or false

    I have the following problem:-

    I want to see if A1 equals any of B1,B2,B3,B4 or B5 i.e anything from a list, and return with C1 or C2 i.e Yes or No.

    If I type in individually B1,B2,B3,B4 or B5 it comes up with the errror "too many arguments".

    If I type in the range B1:B5 it doesn't go through the range of cells and only does the IF equation if the cell equals B1, not any of B1,B2,B3,B4 or B5.

    The range B1:B5 is a list of text and not numbers so I can't use a greather than or less than sum.

    I hope I'm clear on what I'm trying to get at.

    Any help would be greatly appreciated.
    Last edited by johnmitch38; 05-29-2009 at 05:12 AM. Reason: title error

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