How to Use VLOOKUP in Excel

The VLOOKUP function enables you to search for a value in one column and return another from the same row in a different column. As it works from top to bottom, the ‘V’ stands for vertical.

Arguably, it’s the most famous function in Excel and one of the first you’ll learn. It has been ever-present since the program’s birth in 1985!