LOOKUP & REFERENCE FUNCTION
LOOKUP function in MS Excel is used to look in a single row or a column and to find a value from the same position in another row or a column . Reference function is an important function in MS Excel . It refers to a cell or a range of cells on a sheet , which is to be used in a formula so that MS Excel can find those values , that required by the formula to be used .
LOOKUP & REFERENCE FUNCTION
There are total 19 Lookup & Reference Functions in MS Excel . These 19 functions are given below .
1.) ADDRESS : Creates a cell reference as text , given specified row and column numbers.
2.) AREAS : Returns the number of areas in a reference . An area is a range of contiguous cells or a single cell .
3.) CHOOSE : Choose a value or action to perform from a list of values , based on an index number .
4.) COLUMN : Returns the column number of a reference .
5.) COLUMNS : Returns the number of columns in an array or reference .
6.) FORMULATEXT : Returns a formula as a string .
7.) GETPIVOTDATA : Extracts data stored in a PivotTable .
8.) HLOOKUP : Looks for a value in the top row of a table or array of values and returns the value in the same column from a row you specify .
9.) HYPERLINK : Creates a shortcut or jump that opens a document stored on your hard drive , a network server , or on the internet .
10.) INDEX : Returns a value or reference of the cell at the intersection of a particular row and column , in a given range .
11.) INDIRECT : Returns the reference specified by a text string .
12.) LOOKUP : Looks up a value either from a one-row and one-column range or from an array . Provided for backward compatibility .
13.) MATCH : Returns the relative position of an item in a array that matches a specified value in a specified order .
14.) OFFSET : Returns a reference to a range that is a given number of rows and columns from a given reference .
15.) ROW : Returns the row number of a reference .
16.) ROWS : Returns the number of rows in a reference or array .
17.) RTD : Retrieves real-time data from a program that supports COM automation .
18.) TRANSPOSE : Converts a vertical range of cells to a horizontal range, or vice versa .
19.) VLOOKUP : Looks for a value in the leftmost column of a table, and then returns a value in the same row from a column specify . By default, the table must be sorted in an ascending order .
Visit our blogs to know more about excel formulas & functions
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png&description=LOOKUP AND REFERENCE FUNCTIONS IN MS EXCEL){kind=link}
0 Comments