SHEET function - The function returns the worksheet number value of the referenced worksheet in Excel

SHEET function: The function returns the sheet number of the referenced worksheet. Support functions from Excel 2013 onwards. Syntax: SHEET (value)

The following article introduces you to the SHEET function - one of the functions in the group of information functions that is very popular in Excel.

SHEET function - The function returns the worksheet number value of the referenced worksheet in Excel Picture 1SHEET function - The function returns the worksheet number value of the referenced worksheet in Excel Picture 1

Description: The function returns the worksheet number of the referenced worksheet. Support functions from Excel 2013 onwards.

Syntax: SHEET (value)

Inside:

- value: The name of a worksheet or reference to find the page number, is a required parameter.

Attention:

- The use of this function should be restricted in formulas because Excel automatically converts as needed.

For example:

Calculate the number of sheets described in the table below:

SHEET function - The function returns the worksheet number value of the referenced worksheet in Excel Picture 2SHEET function - The function returns the worksheet number value of the referenced worksheet in Excel Picture 2

- In the cell to calculate enter the formula : = SHEET (C6)

SHEET function - The function returns the worksheet number value of the referenced worksheet in Excel Picture 3SHEET function - The function returns the worksheet number value of the referenced worksheet in Excel Picture 3

- Press Enter -> return value is:

SHEET function - The function returns the worksheet number value of the referenced worksheet in Excel Picture 4SHEET function - The function returns the worksheet number value of the referenced worksheet in Excel Picture 4

- Similarly copying the formula for the remaining values ​​results:

SHEET function - The function returns the worksheet number value of the referenced worksheet in Excel Picture 5SHEET function - The function returns the worksheet number value of the referenced worksheet in Excel Picture 5

- You can enter the worksheet name directly in the function:

SHEET function - The function returns the worksheet number value of the referenced worksheet in Excel Picture 6SHEET function - The function returns the worksheet number value of the referenced worksheet in Excel Picture 6

Above are instructions and some specific examples when using SHEET function in Excel.

Good luck!

4 ★ | 2 Vote