Computer Tutoring Logo
Est. 2002
Menu Button

INDEX MATCH for Customer Classification in Google Sheets?



If you've been using VLOOKUP for all of your data lookup and cross references requirements, then you're in for a pleasant surprise. INDEX MATCH will solve a lot of the problems you encounter when using the other one. In fact INDEX MATCH, if you haven't already guessed it, are 2 functions married together. First the INDEX function will allow you to look at a range of data in the first argument. In the second argument, after the comma, you provide a number of the row that contains the value you want to return.

Enter the Match Function. The Match function takes the place of the second argument of the INDEX function. You see, instead of typing in a static value (a value that doesn't change) into the second argument you can enter a formula that will dynamically select that number based on another value. This value is usually a product reference number or name or even and range of data. In this tutorial I show you how to accomplish this by using a range of data. You will learn how to classify data, in this case customers, depending on their spend. So if a customer buys loads from you as a supplier then you will classify them as an "A", if they buy an average amount then you would classify them as a "B" customer. Finally, if they buy only a few items or sales value then they are classified as a "C".

Obviously, this gives you only half the picture but I think you would agree it's a good start. So please enjoy the tutorial and let me know if you have any suggestions on improvements.

Next tutorial - IMPORT RANGE

Should you be interested in taking a Google Sheets training course and see what else you can get out of this amazing spreadsheet package then just let us know.