Skill Level: Intermediate. We all look things up, all the time. Let VLOOKUP and HLOOKUP do some of the work for you! These two power-house functions in Excel automate the ability to find values in a list, long or short. Learn how to search your spreadsheet for particular values in both columns (VLOOKUP) and rows (HLOOKUP) to find information that’s important to you. We’ll also discuss when to use these functions and how to avoid errors.