Using IMPORTRANGE Function in Google Sheets

Article Link: https://spreadsheetpoint.com/how-to-vlookup-from-another-sheet-google-sheets/

With IMPORTRANGE Function in Google Sheets, you can connect two sheets and fetch the data from one sheet into the other.

00:00 Intro
00:10 Why you need IMPORTRANGE in Google Sheets?
00:42 IMPORTRANGE Syntax
01:20 Fetch Data from another Google Sheets file
02:10 Refrence Error when using IMPORTRANGE
02:56 Fetching Data using Named Range
04:01 IMPORTRANGE results updates in real-time

This function could be useful when you are aggregating data from multiple Google Sheets into one Google Sheets document. For example, if you have the score of students in multiple sheets, you can use the IMPORTRANGE function to connect all these and fetch the data into one sheet.

IMPORTRANGE function takes two arguments - the spreadsheet URL and the range string. The URL can easily be copied from the URL bar (or you can copy only the key as shown in the video). In case of range string, you need to specify the sheet name as well as the cell range.

If you're using the IMPORTRANGE function for the first time in a Google Sheets document, it will give a #REF! error when you use it for the first time. You then need to hover over the cell and click on the blue "Allow Access" button to connect the two sheets.

Read More about the IMPORTRANGE Function here: https://productivityspot.com/importrange-function-google-sheets/

Related Video (IMPORTDATA Function): https://www.youtube.com/watch?v=cSyEVCDud8E

Subscribe to this YouTube channel to get updates on Google Sheets Tips and Google Sheets Tutorials videos - https://www.youtube.com/c/spreadsheetpoint

This channel is meant for people who want to learn about Google Sheets and be more productive in their day to day life. It covers a range of Google Sheets topics such as useful Google Sheets features, Google Sheets functions, Google Sheets formulas, Pivot table, Google Apps Script,.Shortcuts, Google Sheets Charting, Data Analysis, etc. Please subscribe to this channel and never miss a new video on Google Spreadsheets

You can also find a lot of useful resources on Google Sheets here: https://spreadsheetpoint.com/

#GoogleSheets #GoogleSheetsTips #Spreadsheet

Видео Using IMPORTRANGE Function in Google Sheets канала Spreadsheet Point