tutorials

INDEX MATCH Step 1

Excel Tutorial: INDEX MATCH primer

Two weeks, we looked at the syntax of VLOOKUP, INDEX and MATCH. Last weeks tutorial should have walked you through the basics of VLOOKUP. In this post, we’ll use a similar file from the VLOOKUP tutorial to find a value from the table using INDEX and MATCH.

Source table

If you haven’t had a chance yet, please go through the VLOOKUP tutorial. Alternatively, if you’re ready to jump right into INDEX/MATCH, then let’s get started.

Firstly, create the above table in Excel. I’ll be using Excel 2010 in my example. You can also download the examples file before you proceed. The file contains a Questions sheet which you can practice in and a Solutions sheet with the answers.

If you haven’t had a chance to review the basic syntax of the functions, please do read this post before you continue.

Read More »Excel Tutorial: INDEX MATCH primer

Advertisements
VLOOKUP Step1

Excel Tutorial: VLOOKUP primer

Last week, I introduced you to VLOOKUP, INDEX and MATCH. In this post, we’ll use VLOOKUP to find a value from the table.

Source table

Firstly, let’s create the above table in Excel. So whip up the installation of Excel you have. You can use either of Excel 2003, Excel 2007 or Excel 2010. I’ll be using Excel 2010 in my example. Download the examples file before you proceed. The file contains a Questions sheet which you can practice in and a Solutions sheet as well.

If you haven’t had a chance to review the basic syntax of the functions, please do read this post before you continue.

VLOOKUP is the easier function of the two to use and understand. It takes just 4 parameters and we’ll be using all 4. And, we’ll look at 4 options of using VLOOKUP.

Read More »Excel Tutorial: VLOOKUP primer

WordPress Picks for the week [11/15]

Managing Comments With Ajax Edit Comments A new version of the very popular plugin Ajax Edit Comments is out. In this guest blog post by Ronald, the founder of Ajax Edit Comments, tells you in pictures all the new features of the plugin. The power that AEC gives you is phenomenal.

Advanced Photo Editing with Tutorials by PhotoBie

At first I thought Photobie no more than a PhotoShop clone – however I was too quick to label it. While it may be similar in nature to PhotoShop (ie its a digital imaging software) that’s about as far as the similarities go! I thought I’d never say this about a software but this one actually has heart!

Learn how to tie a tie

One thing that every guy wants to know (besides how to impress a girl) is how to tie a tie and the site 2tieatie.com hopes to answer this question. 2Tie a Tie gets into the history of various knots and teaches you how to tie them.

Learning at the all new Dummies.com

For Dummies is one of the top selling series of books covering tonnes of topics under the sun. It’s usually one of the first purchases for people who want to start afresh anything from business, to computers and the Internet, electronics, finance etc. Now, For Dummies has relaunched Dummies.