Asked By
Dena Ramos
10 points
N/A
Posted on - 06/01/2020
I’m a user of Excel 2007. I am a beginner and still learning new things about Excel 2007. I have come across a new formula ‘VLookup formula’. I need to know how to use the VLookup formula in Excel 2007?
Want to use VLookup formula in Excel 2007.
The VLookup formula in Excel is used to lookup data in a table. Following are the steps to use VLookup formula in Excel 2007:
- Click on the Formula icon on the ribbon
- Click on the Lookup tab and reference button in the function group.
- Choose VLookup from the function list
This function takes in 4 values as arguments. Enter the values and you’ll get the desired outcome.
Â