Cross-check data to filter numerous rows of data

[noobinexcelvba]

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.

[happyfeet1999]

try vlookup or hlookup function. it quite useful

[FDibbins]

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