You can use your favorite social network to register or link an existing account:
Or use your email address to register without a social network:
Sign in with these social networks:
Or enter your username and password
Forgot your password?
Yes, please link my existing account with for quick, secure access.
No, I would like to create a new account with my profile information.
Bill Jelen found it. Erica Rhein started it. She posted a comment on Facebook declaring her complete dependence on VLOOKUP.
"I use Pivot Tables and VLOOKUP every day. I would be screwed at my job without it"
To Bill's formula-possessed mind this statement equals a love poem. He decided today's VLOOKUP Week door prize would go to the best ode to VLOOKUP. Check out the haikus and poems about undying VLOOKUP love (or is that HOOKUP love?) that have been already submitted, then add your own by entering it as a comment to this post VLOOKUP Week blog post.
BTW: Do you think this entry is the first VLOOKUP love poem ever written?
How do I love thee?Let me count the ways ...
The tens of thousands of records, nay,The now 1,048,576 potential records per sheet,A full 16,384 potential fields wide,Would be a mountain of bad dataToo high to climb...
Whether tracking statewide underground facility excavation violations,National subcontractors' software bug fixes,Or hospital CFOs' every financial metric desires,My eyes grew weary and my fingers waxed numbWith every scroll up and down those endless records,Scanning for that needle of a matching valueIn a towering haystack of a list -Over and over and over again.
One final note: Today Bill's also featuring a post about using VLOOKUP to track shark attacks written by Debra Dalgleish who also wrote about VLOOKUP Vampires. What will Bill possibly give away tomorrow that will relate to these?
Mr. Excel Nice Work of Vlookup Shark Week
I want joined Excel Member Team for Bill Jelen(Mrexcel) and Mike Girvin(Excelisfun)
That day of days when you pluck up
The strength to learn of VLOOKUP
Will stand to you so many ways
And help avoid that sense of daze
That otherwise could wreck your mind
If you were forced to try and find
By manual means those data values
To VLOOKUP- eternal "Thank yous"
The only flaw with Excel...
When you're using a localized version then not only do you get translated menu's and options (which anyone would expect) but also the whole function naming scheme is translated. No offense intended here; but that is something which I consider a massive downside.
Over here in Holland we don't get such excellent tutorials like the stuff you guys are working out here. As such... "VLOOKUP" may leave some of my fellow "Dutchies" wondering what the heck you guys are talking about.
Over here "VLOOKUP" translates back to "VERT.ZOEKEN". ugh... In this case they managed to get it right a little bit, but more than once have I had to look extremely hard to find wth they means.. "find()" isn't "zoeken()" for example (the literal translation of "to find". Nah; its "vind.alles()" which could translate back to "look for everything" or "find everything".
Honestly; when it comes to Excel they should have left the functions alone IMO. Us Dutch will realize that "find" is something to use to 'find' something. IMO the whole translation is only making it harder on the power users to find the stuff they need. Especially in combination with excellent stuff such as this blog (no kidding and no joking; I already pointed quite a few friends over here, and that is something I don't do often).
BUT... apart from that... Excellent article.