HLOOKUP funtion

This function is similar to VLOOKUP but allows you to look up a value in the first row of a range and return the corresponding value in another row. Syntax HLOOKUP(Criteria, Range, Row, Type) Criteria (required) – This is the value you are going to try to find....

ROW function

This function will return the row number of the cell referenced. Syntax ROW(Range) Range (optional) – This is a single cell or range which you want the row number from. For ranges the row number of the upper left most cell will be returned. If no range is...

COLUMN function

This function will return the column number of the cell referenced. Syntax COLUMN(Range) Range (optional) – This is a single cell or range which you want the column number from. For ranges the column number of the upper left most cell will be returned. If no...

ADDRESS function

This function will return the address of a cell given a specified row and column index number. Syntax ADDRESS(Row, Column, Reference Type, Address Type, Sheet Name) Row (required) – This is a number that specifies the row of the address. Column (required)...

CHOOSE function

This function will return a value from a given list of values based on an index number. Syntax CHOOSE(Index, Value1, Value2, Value3,…) Index (required) – This is the index value for the item you want to return from the list. The index number refers to the...