Lookup and reference functions

ADDRESS functionReturns a reference as text to a single cell in a worksheet
AREAS functionReturns the number of areas in a reference
CHOOSE functionChooses a value from a list of values
COLUMN functionReturns the column number of a reference
COLUMNS functionReturns the number of columns in a reference
FORMULATEXT functionReturns the formula at the given reference as text
GETPIVOTDATA functionReturns data stored in a PivotTable report
HLOOKUP functionLooks in the top row of an array and returns the value of the indicated cell
HYPERLINK functionCreates a shortcut or jump that opens a document stored on a network server, an intranet, or the Internet
INDEX functionUses an index to choose a value from a reference or array
INDIRECT functionReturns a reference indicated by a text value
LOOKUP functionLooks up values in a vector or array
MATCH functionLooks up values in a reference or array
OFFSET functionReturns a reference offset from a given reference
ROW functionReturns the row number of a reference
ROWS functionReturns the number of rows in a reference
RTD functionRetrieves real-time data from a program that supports COM automation (Automation: A way to work with an application's objects from another application or development tool. Formerly called OLE Automation, Automation is an industry standard and a feature of the Component Object Model (COM).)
TRANSPOSE functionReturns the transpose of an array
VLOOKUP functionLooks in the first column of an array and moves across the row to return the value of a cell

Post a Comment


Your Comment Will be Show after Approval , Thanks


Subscribe for our all latest News and Updates

Enter your email address: