Vlookup function: Syntax and usage in Excel The Vlookup function is a function that searches for values to return other values in an existing worksheet. Vlookup and Hlookup functions are often used a lot in Excel spreadsheets