Observe: So as to use ImportRange, you should have already been additional like a viewer or collaborator into the spreadsheet from which ImportRange is pulling the info. Or else, you will get this error: "#REF! mistake: The asked for spreadsheet critical, sheet title, or mobile selection wasn't identified." This post https://case-study-help19446.like-blogs.com/37007719/what-does-case-study-solution-mean