Note: So that you can use ImportRange, you have to are actually extra to be a viewer or collaborator to the spreadsheet from which ImportRange is pulling the information. Or else, you will get this mistake: "#REF! mistake: The requested spreadsheet important, sheet title, or mobile variety wasn't observed." Thankfully, https://claytoncxbmb.blogdigy.com/rumored-buzz-on-harvard-case-study-analysis-57182435