Excel Lookup And Reference Functions

This section will learn  how to use Excel’s Lookup And Reference Functions such as: Address, Areas, Columns, Hlookup, Vlookup, Lookup, Index, Match, etc.

ADDRESS – returns a reference as a text string to a single cell.

AREAS – returns the number of ranges in a reference.

CHOOSE – returns a value from a list of values.

COLUMN – returns the first column number of the given cell reference.

COLUMNS – returns the number of columns in an Array or a reference.

HLOOKUP – lookup a value in the top row of the table and return the value in the same column based on index_num position.

HYPERLINK – creates a shortcut/hyperlink to a document, when you click this hyperlink, the excel will open the file that is stored on a network server or local location.

INDEX – returns a value from a table based on the index (row number and column number)

INDIRECT – returns the cell reference based on a text string, such as: type the text string “A2” in B1 cell, it just a text string, so you can use INDIRECT function to convert text string as cell reference.

LOOKUP – search a value in a vector or array.

MATCH – search a value in an array and returns the position of that item.

ROW – returns the row number of a cell reference.

ROWS – returns the number of rows in a cell reference.

VLOOKUP – lookup a value in the first column of the table and return the value in the same row based on index_num position.

Leave a Reply