+ Reply to Thread
Results 1 to 2 of 2

Verify Data List

  1. #1
    Registered User
    Join Date
    11-06-2003
    Posts
    1

    Red face Verify Data List

    Can Anyone Help?
    I Have A List Of 3000+ Company Names On A Ledger, And Some Of These Have Been Incorrectly Spelt, Entered Etc.

    I Need To Be Able To Check To See If Which Company Names From List A1-a3000 Do Not Equal Any Of The Company Names From List B1-b250
    Highlighting The Incorrect Item In Cells C1-c3000 With A "ok" Or "check Dat" Flag.

    List B1-b250 Are The Correct Items
    List A1-a3000 Have Been Entered But Many Are Incorrect.

    Thanks.,

  2. #2
    Forum Contributor
    Join Date
    12-02-2004
    Location
    London
    Posts
    255
    Enter the following formula in cell c1 and copy it down to cell c3000

    if(isna(vlookup(A1,B$1:B$250,1,false)),"Check dat","OK")

+ Reply to Thread

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