Observe: So that you can use ImportRange, you'll want to are actually added to be a viewer or collaborator on the spreadsheet from which ImportRange is pulling the information. If not, you'll get this mistake: "#REF! error: The requested spreadsheet key, sheet title, or mobile assortment was not found." If https://hbscasestudysolution60878.blogdeazar.com/37511479/details-fiction-and-hbs-case-help