Heading Spreadsheet If there is a value within the range, I want to extract it to another sheet.

I have A and B sheets in the same spreadsheet.

4th row of B sheet CT: If there is a value within the CZ range
I would like to reflect that data in the AG of the A sheet.

= IMPORTRANGE ("Spreadsheet Key", "B! CT4: CZ4")
I can get the range data of another sheet with the importrange function, but in this case I will get the data within the range, so if there is data, I want to display it in only one cell (AG4).

If anyone knows, please let me know.

  • Answer # 1

    If there is only one value in the range, you don't have to worry about the delimiter, so let's integrate the range with TEXTJOIN.
    If all are blank, blank will be returned.

    = TEXTJOIN (, TRUE, IMPORTRANGE ("spreadsheet key", "B! CT4: CZ4"))

Related articles