IMPORTRANGE function - Zoho Sheet - Help Guide

IMPORTRANGE

Imports values from a given range of cells from another specified spreadsheet (workbook) in Zoho Sheet.

 

Syntax

 

IMPORTRANGE( spreadsheet_url; range )

spreadsheet_url : The link of the source spreadsheet from where the range is to be imported. Eg., " https://sheet.zoho.com/sheet/open/c2zep9f2d2676610d426fb3ab9652164d0f87 "

range_string : The reference of the range to be imported. Eg., "Sheet1.A2:F10"

 

Remarks

  1. The source spreadsheet must be linked in order to pull data using IMPORTRANGE function.
  2. The user must have access to the source spreadsheet to link it.
  3. The values get auto-updated when there is a change in the source range.
  4. You can also copy the desired cell range from the source file and use Paste > Link option in the destination file to use the IMPORTRANGE() function with ease.


Examples

 

Formula

=IMPORTRANGE(" https://sheet.zoho.com/sheet/open/c2zep9f2d2676610d426fb3ab9652164d0f87 " ;"Sheet1.A2:F10")

=IMPORTRANGE("c2zep9f2d2676610d426fb3ab9652164d0f87";"Sheet2.A2:D2")

   

Get a hands-on experience of the function in the embedded range below.



Possible Errors

 

Errors

Meaning

#N/A!

  • The function could not find the value it was asked to look for. Commonly occurs in VLOOKUP and similar functions.

#NAME!

  • The function name is incorrect or invalid.

  • The given defined name (if any) is invalid.

  • There is a typo in the defined name used in the function.

  • Double quotes are missing for text values in the function.

  • Colon missing in a cell range reference.

#VALUE!

  • The given argument's data type is incorrect or invalid.
    For example, the function =DATE(A1:A3) will return a #VALUE error when a text value is present in the range.

#REF!

  • The given cell reference is incorrect or invalid. This error may occur when a cell/range has been deleted, moved, or pasted over.