Function | Description |
CHOOSE(num,value1[,value2,...]) | Uses num to select one of the list of
arguments given by value1, value2, and so on |
GETPIVOTDATA(data,table,field1,item1,...) | Extracts data from a PivotTable |
HLOOKUP(value,table,row[,range]) | Searches for value in table and returns the value in the specified row |
INDEX(ref,row[,col][,area]) | Looks in ref and returns the value of the cell at the intersection of row and, optionally, col |
LOOKUP(lookup_value,...) | Looks up a value in a range or array (this function has been replaced by the HLOOKUP() and VLOOKUP() functions) |
MATCH(value,range[,match_type]) | Searches range for value and, if found, returns the relative position of value in range |
RTD(progID,server,topic1[,topic2,...]) | Retrieves data in real time from an automation server |
VLOOKUP(value,table,col[,range]) | Searches for value in table and returns the value in the specified col |