I was trying to compare the employees data in 2 diffwerent excel sheets. I cannt do it manually, because the records are 150000. I need some help on this. How to do it using vlookup can you please explain me in detail. how to write the formula. Thanks, Sirisha.
Reply from Richard Rost:
Any time you're dealing with more than a few HUNDRED records, I would definitely move from Excel up to an ACCESS DATABASE. Excel is not that great for working with huge lists of data. If you just want to see if someone in Sheet1 is also listed in Sheet2, then yes, you could use a VLOOKUP statement, or the INDEX and MATCH functions. See those links for more help.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Excel Forum.
