In Microsoft Excel, the Vlookup function is used for searching through multiple values positioned vertically in a spreadsheet. It can be quite useful when you're trying to create a formula-full spreadsheet without any cells containing manually-entered data. If there are multiple values in the Excel columns in question, use the Vlookup function to find and display one of them in the cell of your choice.
- Skill level:
- Moderately Easy
Other People Are Reading
Click to select the cell where you'd like to insert the Vlookup function and open the "Formulas" tab.
Click on the "Insert Function" button, select "All" from the "Or select a category" drop-down menu, scroll down the "Select a function" list to select "VLOOKUP," and then click "OK."
Enter in the desired column numbers containing the multiple values you'd like Vlookup to use and enter the value or text you're searching for. Click "OK" when ready to insert the Vlookup function. It will immediately search through the multiple values in the columns you entered and return the desired value.
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for