-
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…
-
Grado iGi In-Ear Headphones Review
Santa was good to me this year. I’ll use the next few posts to talk about some of the shiny toys I’ve been playing with, but today I’d like to focus on my new headphones: Grado Labs iGi In-Ear Headphones. Grado Labs is a family owned company based out of Brooklyn, NY, probably best known for…
-
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…