Appendix G: Excel Spreadsheets Lookup and Reference Functions (18)
This web page is an appendix. For more see Excel LookUp and References formulas in lesson 3-13
| Importance | Functions | What it Does |
| Essential | INDEX | Uses an index to choose a value from a reference or array |
| Interesting | INDIRECT | Returns a reference indicated by a text value |
| Essential | MATCH | Looks up values in a reference or array |
| Interesting | OFFSET | Returns a reference offset from a given reference |
| Interesting | ADDRESS | Returns a reference as text to a single cell in a worksheet |
| Rarely Used | AREAS | Returns the number of areas in a reference |
| Rarely Used | COLUMN | Returns the column number of a reference |
| Rarely Used | COLUMNS | Returns the number of columns in a reference |
| Rarely Used | CHOOSE | Chooses a value from a list of values |
| Rarely Used | GETPIVOTDATA | Returns data stored in a PivotTable |
| Obsolete | HLOOKUP | Looks in the top row of an array and returns the value of the indicated cell |
| Rarely Used | HYPERLINK | Creates a shortcut or jump that opens a document stored on a network server, an intranet, or the Internet |
| Obsolete | LOOKUP | Looks up values in a vector or array |
| Rarely Used | ROW | Returns the row number of a reference |
| Rarely Used | ROWS | Returns the number of rows in a reference |
| Rarely Used | RTD | Retrieves real-time data from a program that supports COM automation (Automation : Façon de travailler avec les objets d'une application à partir d'une autre application ou d'un autre outil de développement. Autrefois appelée OLE Automation, Automation es |
| Rarely Used | TRANSPOSE | Returns the transpose of an array |
| Obsolete | VLOOKUP | Looks in the first column of an array and moves across the row to return the value of a cell |