how many lookups and reference functions?
Answers
Lookup & Reference functions help you to work with arrays of data, and are particularly useful when you need to cross reference between different data sets. They perform tasks such as providing information about a range, returning the location of a given address or value, or looking up specific values.
Lookup and Reference Functions
The following table lists all the Lookup & Reference functions −
S.No. Function and Description
1 ADDRESS
Returns a reference as text to a single cell in a worksheet
2 AREAS
Returns the number of areas in a reference
3 CHOOSE
Chooses a value from a list of values
4 COLUMN
Returns the column number of a reference
5 COLUMNS
Returns the number of columns in a reference
6 FORMULATEXT
Returns the formula at the given reference as text
7 GETPIVOTDATA
Returns data stored in a PivotTable
8 HLOOKUP
Searches for a value in the top row of a table and then returns a value in the same column from a row you specify in the table
9 HYPERLINK
Creates a shortcut that opens a document on your hard drive, a server, or the Internet
10 INDEX
Uses an index to choose a value from a reference or array
11 INDIRECT
Returns a reference indicated by a text value
12 LOOKUP
Returns a value either from a one-row or one-column range or from an array
13 MATCH
Returns the relative position of an item in an array
14 OFFSET
Returns a reference offset from a given reference
15 ROW
Returns the row number of a reference
16 ROWS
Returns the number of rows in a reference
17 RTD
Returns real-time data from a program that supports COM automation
18 TRANSPOSE
Returns the transpose of an array
19 VLOOKUP
Searches for a value in the leftmost column of a table and then returns a value in the same row from a column you specify in the table
Hope this helps u
see the above attachment please
