Skip to content
Google Sheets

CELL function in Google Sheets

Returns the requested information about the specified cell.

=CELL(info_type, reference)

CELL syntax and parameters

Two arguments, two required.

  • info_typestringRequired

    The type of information requested.

  • referencerangeRequired

    The reference to the cell.

CELL examples

Formulas you'll actually reuse.

  1. The address of the biggest value in a column:

    =CELL("address", INDEX(B2:B50, MATCH(MAX(B2:B50), B2:B50, 0)))

    Result"$B$17"

  2. Same trick, but just the row number for a jump link:

    =CELL("row", INDEX(B2:B50, MATCH(MAX(B2:B50), B2:B50, 0)))

    Result17

CELL in Excel

Same name — your formula ports as-is.

Try CELL in the playground

Edit the example — nothing to install.

Preloaded with the CELL formula from Example 1 — change anything and watch it respond.

Loading the editor…

Related functions

More ways Google Sheets gets this done.