VLOOKUP in Excel 2007

Searches for a value in the first column of a table array and returns a value in the same row from another column in the table array.