And the first response is this:Question:
I have to look up a specific SS# on three different sheets of the same workbook, because each of the sheets has more than 65536 rows (it is really one list but has to be divided up due to the size). How to make a vlookup formula to look on each of the three sheets? The sheets are named 2-16, 17-33, 34-63. TIA for any help!
In this case, using Access would be easier
I agree with this. In this case it might be clear that Access is THE tool, but it is not sure that the Original Poster can spend much time to learn this new tool for a task which occurs only once in a while...should have addressed the issue as well
Everyone seems to be describing me as being able to unleash some sort of "wrath" lately, but I wouldn't be too worried.Obviously, you don't want to go violating the forum rules (http://www.mrexcel.com/board2/viewtopic.php?t=103030) or you'll face the wrath of Kristy and have your post deleted.
I will do my best to ward off the Snark by not being to annoying!
"I am teh captain of the carpet ship!"What does the tiny text in your avatar say?