You often do a vertical lookup search in real-life situations, such as looking at a restaurant menu. You’ll look at the corresponding price in another column to the menu items. The VLOOKUP Sheets function works similarly, as it retrieves data from one column and shows the matching data in the corresponding cell.