How to use the VLOOKUP function in Microsoft Excel to find related data points in your worksheet

The VLOOKUP formula in Excel is great for finding relationships between different data points.
justplay1412/Shutterstock
You can use the VLOOKUP function in Microsoft Excel to write a simple formula that will find specific data points you're looking for.
To use VLOOKUP in Excel, open the "Formulas" menu at the top of the screen.
The VLOOKUP function is most helpful when you're trying to find a specific value in a large spreadsheet.
The "V" in VLOOKUP stands for vertical, meaning Excel will scan