MS-Excel / Functions and Formula

Excel's Lookup Functions

FunctionDescription
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
[Contents] [Next]