See Also:
Office.com results
DATE function
Article Syntax: DATE(year, month, day)
Excel 2007
HLOOKUP function
Article Searches for a value in the top row of a table or an array of values, and then returns a value in the same column from a row you specify in the table or arra...
Excel 2007
INDEX function
Article Syntax: INDEX(array,row_num,column_num)
Excel 2007
INT function
Article Rounds a number down to the nearest integer. Syntax INT ( number ) Number   is the real number you want to round down to an integer. Example The example may be ...
Excel 2007
IS functions
Article This article describes the formula syntax and usage of the IS functions in Microsoft Office Excel. Description Each of these functions, referred to collecti...
Excel 2007
Look up values in a list of data
Article In Excel 2007, look up data to find data in a list and verify that it's correct. Then, perform calculations or display results with the values returned.
Excel 2007
Lookup and reference functions (reference)
Article Excel 2007 comes with multiple Lookup and Reference functions that let you find matching values. Use this article to decide which function is best for your need...
Excel 2007
LOOKUP function
Article Show All Hide All This article describes the formula syntax and usage of the LOOKUP function (function: A prewritten formula that takes a value or values, perfo...
Excel 2007
MATCH function
Article Syntax: MATCH(lookup_value, lookup_array, [match_type])
Excel 2007
YEARFRAC function
Article Calculates the fraction of the year represented by the number of whole days between two dates (the start_date and the end_date). Use the YEARFRAC worksheet func...
Excel 2007