If you've been using Excel and are used to creating formula that calculate values based on different spreadsheets then you may have been frustrated when you tried to do the same in Google Sheets. Why is that? Well, the problem is that the Google sheets spreadsheets exist online. That being the case you need to provide a URL (Uniform Resource Locator) or web address within the formula.
Coupled with that you need to allow persmission for one Google sheet to talk to another and that's where this video tutorial comes in
This is the 3rd in the series of customer classification and taking it to a whole new level you will see how you can get data from an entirely different sheet with the IMPORTRANGE function.
If you would like to take this a little further and maybe see how this can be appied to your organisation then get yourself on a tutor led training course.