+ Reply to Thread
Results 1 to 3 of 3

Cross-check data to filter numerous rows of data

  1. #1
    Registered User
    Join Date
    05-08-2012
    Location
    Philippines
    MS-Off Ver
    Excel 2003
    Posts
    1

    Question Cross-check data to filter numerous rows of data

    Hi! I am a novice in Excel VBA so I don't really know how to work my way around codes. Anyway, I am working on 628,425 rows of data. In order to filter this, I need to cross check it against a list of data that I have. Is there a way to do this? I've tried IF ELSE statement, but it's not very flexible.


    I hope you understood my dilemma as this is the only information I can give for now because the data is confidential.

    Thank you very much. It would mean a lot.
    Last edited by noobinexcelvba; 05-08-2012 at 10:47 PM.

  2. #2
    Registered User
    Join Date
    05-08-2012
    Location
    singapore
    MS-Off Ver
    Excel 2003
    Posts
    1

    Re: Cross-check data to filter numerous rows of data

    try vlookup or hlookup function. it quite useful

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    48,642

    Re: Cross-check data to filter numerous rows of data

    if the data you want, repeats itself in your data base, a vlookup will only return the 1st instance of that search. what do you want to do with the data that is found? maybe a pivot table would help you with what you need, and maybe you could upload a dummy sample of your data for us to look at (i understand its confidential, but its a little hard to generate a solution blind?)

    if the data you are looking for, then happyfeet's solution will probably work for you, depending on the column layout of the data and your filter table. this is how a vlookup works...

    =vlookup(cell-to-find,range-to-search-in,column-to-search-in (a number, starting from 1 as the 1st col in the range),false) the false is for if you are searching in unsorted data
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ Reply to Thread

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