Contents
An Introduction to Excel Functions
Financial Functions
Date and Time Functions
Math and Trigonometry Functions
Statistical Functions
Lookup and Reference Functions
Database Functions
Text Functions
Logical Functions
Information Functions
Engineering Functions
Cube Functions
Add-In and Automation Functions
|
 |
 |
 |
|
Lookup and Reference Functions
Function |
Description |
Syntax |
||
ADDRESS |
Returns a reference as text to a single cell in a worksheet |
(row_num,column_num,
abs_num,a1,sheet_text) |
||
AREAS |
Returns the number of areas in a reference |
(reference) |
||
CHOOSE |
Chooses a value from a list
of values |
(index_num,value1,value2,...) |
||
COLUMN |
Returns the column number of
a reference |
(reference) |
||
COLUMNS |
Returns the number of columns in a reference |
(array) |
||
HLOOKUP |
Looks in the top row of an
array and returns the value of the indicated cell |
(lookup_value,table_array,
row_index_num,
range_lookup) |
||
HYPERLINK |
Creates a shortcut or jump that opens a document stored on a network server, an intranet, or the internet |
(link_location,
friendly_name) |
||
INDEX (array form) |
Returns the value of an element in a table or an array |
(array,row_num,
column_num) |
||
INDEX (reference form) |
Returns the reference of the cell at the intersection of a particular row and column |
(reference,row_num,
column_num,area_num) |
||
INDIRECT |
Returns a reference indicated by a text value |
(ref_text,a1) |
||
LOOKUP (vector form) |
Looks in a one-row or one-
column range (known as a vector) for a value and returns a value from the same position in a second one-row or one-
column range |
(lookup_value,
lookup_vector,result_vector) |
||
LOOKUP (array form) |
Looks in the first row or column of an array for the specified value and returns a value from the same position in the last row or column of the array |
(lookup_value,array) |
||
MATCH |
Looks up values in a reference or an array |
(lookup_value,lookup_array,
match_type) |
||
OFFSET |
Returns a reference offset from a given reference |
(reference,rows,cols,height,
width) |
||
ROW |
Returns the row number of
a reference |
(reference) |
||
ROWS |
Returns the number of rows in
a reference |
(array) |
||
RTD |
Retrieves real-time data from a program that supports COM automation |
(ProgID,server,topic1,
[topic2],...) |
||
TRANSPOSE |
Returns the transpose of
an array |
(array) |
||
VLOOKUP |
Looks in the first column of an array and moves across the row to return the value of a cell |
(lookup_value,table_array,
col_index_num,
range_lookup) |
| Acknowledgments & Disclaimer |
Tags
No one has tagged this page yet... Be the first.. Log in using the link below and return to add your tag
