This tutorial video is the first in a 3 part dealing with using VLOOKUP to classify customers by spend. This tutorial will show you how to use VLOOKUP in Google sheets and in particular how to use the final is_sorted argument to look up a range of date.
The next tutorial will show you how to use INDEX MATCH to do the same and will give you 2 reasons as to why INDEX MATCH is superior to VLOOKUP.
The final tutorial will show you how to incorporate the INDEX MATCH functions across separate Google Sheets.
Next Tutorial - INDEX MATCH
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.