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.