Use the Vlookup function in Microsoft Excel 2007 to return data from a range of cells. Vlookup looks vertically down a column and returns data from a different column for that record.