CELL Function to Look Up Information of a Cell in Excel

This article provides a clear overview of CELL Function to Look Up Information of a Cell in Excel, with the main facts, useful context, and practical details organized for easy reading.

The article describes in detail the syntax and usage of the CELL () function to look up a cell's information in Excel ().

Description

CELL () returns the format, position, or content information of a cell depending on your needs. When you need to look up a cell's information, CELL () is the most used function.

Syntax

= CELL (info_type, reference)

Arguments

- info_type: type of lookup information you want the CELL () function to return.

- reference: the cell or range you may need to look up information.

+ If reference is omitted, the function will default to return information of the cell containing the CELL () function.

+ If reference is a range of cells or a reference to a range of cells, CELL () results in the information of the top-left cell on the range of cells and range of cells.

Note

- Table of values of the Info_type argument and results returned.

- The following table describes the value that the CELL () function returns when the Info_type argument is "format".

- Info_type must be entered in quotation marks, otherwise CELL () will return the #NAME! Error.

- If info_type is not appropriate, CELL () returns the #VALUE! Error.

For Example

The article introduced to you CELL () function to look up information of a cell in Excel. CELL () function supports many types of information that you can look up, tailored to each person's needs. When you need to look up information, you can choose the type of information to look up for the request. Good luck!