-
Compare two or more lists in Excel with VLOOKUP
Nearly seven (seven!) years ago, I wrote a post that helped people compare two or more lists in Excel with ISNA and MATCH. It’s the second most popular post on Big Hungry Geek, right behind my post about merging worksheets in Excel, which has been the number one fan favorite for several years running. Since…
-
How to Use VLOOKUP in Excel
If you’re looking for the pound for pound, biggest bang for your buck, insert-trite-stereotyped-expression-here, Most Valuable Excel Function, a function that, when properly used, will dramatically increase your Excel mojo, impress your bosses, and make you look like an Excel pro, then let’s talk about Excel’s VLOOKUP function. Yes, it’s an old-timer as far as Excel functions…
-
Merge Worksheets in Excel
It’s no secret that I love Excel. I’ve said it before, I’ll say it now and I’m sure I’ll hum this tune again next week. Today I’m tackling a common problem that’s plagued office heroes for years. How do you merge multiple Excel worksheets into one master worksheet, automatically, and without macros or VBA? Down the line…
-
Starting My Bilingual Summer
Christine Gilbert, author of the wonderful and inspiring travel lifestyle blog Almost Fearless, recently wrote about her intention to learn a new language this summer, and challenged her readers to join. Well, join and compete with her, using Duolingo, a free online language learning site promising no ads or hidden fees now and forever. That’s right, free, forever. I’ve been…
-
Want Hotel Status and Upgrades? Just Ask.
OK first of all, the Starwood Preferred Guest (SPG) program is amazing. In fact I’m comfortable declaring that it’s my hands-down favorite and the best loyalty rewards program I’ve ever used to date. The reasons are many, but I’ll save extolling these virtues for a later post. Before I go on gushing and retell how…
-
Save at Airports: Bring Your Empty Water Bottle
If you find yourself trudging through airports every week, as I often do, I don’t doubt you’ve noticed that bottled water doesn’t sell for less than $3. Quite often even that is cheap. Nearly ever week since January I’ve wandered through terminals searching for bottled water, and nearly every week I shout (in my head)…