Reference Function

 

3.1) Address: This function find the address of a cell in a worksheet, given specific row and column numbers.

Syntax= ADDRESS(row_num, column_num, [abs_num], [a1], [sheet_text])

Example

1.png

3.1) Address: This function find the address of a cell in a worksheet, given specific row and column numbers.

Syntax= ADDRESS(row_num, column_num, [abs_num], [a1], [sheet_text])

Example

1.png
 

3.2) Choose: This function uses index_num to return a value from the list of value arguments.

 Syntax = CHOOSE(index_num, value1, [value2],...)

 Example

2.png
 

3.3) Column: This function find out column number

 Syntax = COLUMN([reference])

Example

3.png
 

3.4) Columns: This function find out column number of array

 Syntax= COLUMNS(array)

 Example

4.png
 

3.5) Row: This function return the row number

 Syntax= ROW([reference])

 Example

5.png
 

3.6) Rows: This function return the row number from array

 Syntax= ROWS(array)

 Example

6.png

Want More Basic Excel Deep Dives