Category: Lookup and Reference

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...

Read More

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...

Read More

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...

Read More

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...

Read More

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...

Read More
Loading

Follow Us

Advertisement

Free Book

Categories

Advertisement

Pin It on Pinterest