-
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…
-
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)…
-
Dynamic Data Validation with Excel 2010 & 2013
It’s Christmas, and like many of you I find myself thinking about dynamic data validation using the structured tables that Microsoft introduced in Excel 2010. Welcome to my life. What’s Data Validation? When I say data validation I mean the ability to specify exactly what kind of data users may (or may not) enter into…