In Excel, the VLookup function searches for value in the left-most column of table_array and returns the value in the same row based on the index_number.