How to Use Vlookup for Multiple Values in Excel

Written by daniel hatter Google
  • Share
  • Tweet
  • Share
  • Email

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


  1. 1

    Click to select the cell where you'd like to insert the Vlookup function and open the "Formulas" tab.

  2. 2

    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."

  3. 3

    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.

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.