Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.

April 2012 - The Excel Team Blog

The Excel Team Blog
  • Using multiple criteria in Excel Lookup formulas

    If you want to look up a value in a table using one criteria, it's simple. You can use a plain VLOOKUP formula. But if you want to use more than one criteria, what can you do? There are lots of ways using several Excel functions such as VLOOKUP, LOOKUP, MATCH, INDEX, etc. In this blog post, I'll show you a few of those ways. ...( read more ) Read More...
  • And the winner of the VLOOKUP Great White Shark Award is...

    JP Pinto! Congratulations! His post was one of seven chosen by Bill Jelen as the most innovative ones published during VLOOKUP Week . He won a copy Bill Jelens book Microsoft Excel 2010 In Depth. You can find links to all seven posts and see the voting results in our wrap-up post of VLOOKUP Week . ...( read more ) Read More...
  • VLOOKUP Week Wraps Up: Vote For Your Favorite Post

    VLOOKUP Week has ended. The brainchild of Excel MVP Bill Jelen, the idea inspired all things VLOOKUP, including VLOOKUP odes, haikus, vampires, and a way to track shark attacks. Setting all fun aside--Excel experts created a crazy number of useful and innovative applications of VLOOKUP in seven days. The week might be over, but thanks to the enthusiasm of the Excel community and to the Web, the information will continue to instruct Excel users at all levels of expertise. So thanks, Bill, and thanks...
  • Excel: not just for geeks

    Ugh. Excel. It's not as intuitive as a Word doc, and not as aesthetically pleasing as a PowerPoint presentation. If you're more creative than analytical, you might feel as though it's dry and boring and filled with numbers you'd rather not look at. However, I can tell you that after you familiarize yourself with it, it is the best tool Microsoft Office has - and extremely easy to use! This guest post is written by Divya Bahl, a blogger for the popular site Her Campus . ...( read more...
Copyright Excel User Group and the relevant contributors, 2010. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.