## 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.

## 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. Firstly, let's create the above table in Excel.

## Excel Tutorial: Introduction to VLOOKUP, INDEX and MATCH functions

Excel has several  lookup and reference functions. The main purposes of most of the plugins is to lookup some cell or cells from a set of data (usually presented in a table). Of these, the most popular ones are VLOOKUP, INDEX and MATCH.

## 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.

## How to easily grab webpage embedded media in Firefox

First, a short disclaimer: This post merely shows you a method. You alone are entirely responsible for what you use it for. There are times when we need to grab media like images, audio and sometimes even embedded video files from various sites.

## 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.

## Win a Membership to OnlineProfits.com

OnlineProfits.com launched this Monday with \$50 off on their monthly price of \$98. I decided to signup considering the big names and especially checking out the content they have on offer.

## 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.