Results 1 to 3 of 3

Thread: Help needed for "find"

  1. #1

    Help needed for "find"



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

    I have a huge column A with some data, on another sheet or on the same sheet I have another column B with some other data...

    Is it possible and how should I tell excel to search individualy all values from column "A" in column "B" and if column "B" contains values that exist in column "A" then let the next right neighbouring cell (to column "A" cell) turn into green or let there appear "ok" notification...


    May u pls help i need this urgently
    thank u

  2. #2
    Look at conditional formatting http://www.contextures.com/xlCondFormat01.html

  3. #3
    Seeker Armando L Franco's Avatar
    Join Date
    Aug 2011
    Location
    Ensenada, Baja California, Mexico
    Posts
    5
    Articles
    0
    Insert a column next to A. This will make column B your column C.
    Then enter this formula (I am assuming you start in cell b2).
    =if(iserror(vlookup(a2,C:C,1,0)),"","OK")
    This will display OK if it exists, leave it blank if it does not.

Posting Permissions

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