Results 1 to 4 of 4

Seaching a text list using IF

Threaded View

  1. #1
    Registered User
    Join Date
    03-13-2010
    Location
    Bedfordshire, England
    MS-Off Ver
    Excel 2010
    Posts
    60

    Seaching a text list using IF

    I have a list of codes in text form, I want a cell (L35) to return YES it sees a code in another referenced cell (L36) and stay blank if not. The code list is L93 to L100. I can use the IF statement and get it to work using only one cell in the list but not if I use the whole list. Can I use IF to do this or do I need another statement.


    This code works
    =IF(L36=L93,"YES","")
    I thought this may work but does not.
    =IF(L36=L93;L125,"YES","")
    Last edited by BobTheRocker; 11-24-2010 at 08:01 AM.

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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