Lookup / Reference Functions

[Rishabh SuranaModerator]

ADDRESS >>> Returns a text representation of a cell address

AREAS >>> Returns the number of ranges in a reference

CHOOSE>>> Returns a value from a list of values based on a given position

COLUMN >>> Returns the column number of a cell reference

COLUMNS >>> Returns the number of columns in a cell reference

HLOOKUP >>> Performs a horizontal lookup by searching for a value in the top row of the table and returning the value in the same column based on the index_number

HYPERLINK >>> Creates a shortcut to a file or Internet address

INDEX >>> Returns either the value or the reference to a value from a table or range

INDIRECT >>> Returns the reference to a cell based on its string representation

LOOKUP >>> Returns a value from a range (one row or one column) or from an array

MATCH >>> Searches for a value in an array and returns the relative position of that item

OFFSET >>> Returns a reference to a range that is offset a number of rows and columns

ROW >>> Returns the row number of a cell reference

ROWS >>> Returns the number of rows in a cell reference

TRANSPOSE >>> Returns a transposed range

of cells

VLOOKUP >>> Performs a vertical lookup by searching for a value in the first column of a table and returning the value in the same row in the index_number position

Sent from my SM-A605G using Actuarial Info mobile app

[Mayank GoyalKeymaster]

RISHABH wrote:

ADDRESS >>> Returns a text representation of a cell address

AREAS >>> Returns the number of ranges in a reference

CHOOSE>>> Returns a value from a list of values based on a given position

COLUMN >>> Returns the column number of a cell reference

COLUMNS >>> Returns the number of columns in a cell reference

HLOOKUP >>> Performs a horizontal lookup by searching for a value in the top row of the table and returning the value in the same column based on the index_number

HYPERLINK >>> Creates a shortcut to a file or Internet address

INDEX >>> Returns either the value or the reference to a value from a table or range

INDIRECT >>> Returns the reference to a cell based on its string representation

LOOKUP >>> Returns a value from a range (one row or one column) or from an array

MATCH >>> Searches for a value in an array and returns the relative position of that item

OFFSET >>> Returns a reference to a range that is offset a number of rows and columns

ROW >>> Returns the row number of a cell reference

ROWS >>> Returns the number of rows in a cell reference

TRANSPOSE >>> Returns a transposed range

of cells

VLOOKUP >>> Performs a vertical lookup by searching for a value in the first column of a table and returning the value in the same row in the index_number position

Sent from my SM-A605G using Actuarial Info mobile app

This is nice! thanks

[Author]

Posts