How To Use VLOOKUP in Excel 2013

how to vlookup lead 675403

Microsoft Excel 2013 boasts a huge number of handy functions and utilities, many of which go unused by the average user. If you find yourself frequently needing to consult a table to find the same data, however, you’ll probably want to learn how to use VLOOKUP. Short for “vertical lookup,” VLOOKUP takes advantage of vertically-aligned tables to quickly find data associated with a value the user enters.

If you know the name of a product, for instance, and you want to quickly determine its price, you can simply enter the product name into Excel and VLOOKUP will find the price for you. To the novice Excel user, however, setting up VLOOKUP can look like an intimidating process — but it needn’t be. Just follow our step-by-step tutorial to start using VLOOKUP today. 

1. Click the cell where you want the VLOOKUP formula to be calculated.

how to vlookup 1 675403

2. Click “Formula” at the top of the screen.

how to vlookup 2 675403

3. Click “Lookup & Reference” on the Ribbon.

how to vlookup 3 675403

4. Click “VLOOKUP” at the bottom of the drop-down menu.

how to vlookup 4 675403

5. Specify the cell in which you will enter the value whose data you’re looking for. In this case, our lookup value is H2, since this is where we will input the name of a tournament such as “PGA Championship,” so we input “H2″ in the lookup_value box of the popup window. Once we’ve set up VLOOKUP properly, Excel will return the tournament’s Total Rating Value in cell H3 when we type the tournament name in cell H2.

how to vlookup 5 675403

6. Specify the data which you want VLOOKUP to use for its search in the table_array box. In this case, we’ve selected the entire table (excluding the headers).

how to vlookup 6 675403

7. Specify the column number which VLOOKUP will use to find the relevant data in the col_index_num box. Somewhat confusingly, VLOOKUP requires you to use the numerical value of the of the column rather than its letter value. In this case, we want VLOOKUP to use the Total Rating Value column — column D — so we enter the number 4.

how to vlookup 7 675403

8. Specify whether you need an exact match by entering either FALSE (exact match) or TRUE (approximate match) in the range_lookup box. In this case, we want an exact match so we enter FALSE.

how to vlookup 8 675403

9. Click “OK” at the bottom of the popup window.

how to vlookup 9 675403

10. Enter the value whose data you’re searching for. In our example, we want to find the Total Value Rating of the PGA Championship, so we type “PGA Championship” into cell H2 and VLOOKUP automatically produces the Total Value Rating (in this case, 914) in cell H3.

how to vlookup 10 675403

Using VLOOKUP, you can not only search for individual values, but also combine two worksheets into one. For example, if you have one worksheet with names and phone numbers and another sheet with names and email addresses, you can put the email addresses next to the names and phone numbers by using VLOOKUP. 

Email* (will not be published)
*Indicates required field
Submit Comments

  1. Excel Training Courses Says:

    VLOOKUP is an extremely useful tool, and learning how to use it is easier than you think!
    Great post! Thanks a lot for sharing the useful information.

  2. john Says:

    This site is useless.

  3. Saffron Says:

    phweew! Thank you, I knew it had to be easy.. just needed to turn it into a table! Thank you for this article! Saving me TONS of time!

  4. Katt Says:

    You did not mention that when the data table that you are working with contains merged cells you must use the number of the 1st cell of the merged cells as if the merge did not exist. Example: if you have 3 merged cells in your table you are not going to use 1,2,3 to access the data. You will use 1, 4, 10 depending on the size of each of the merged cells and at what numerical location each one starts in the table.

  5. Pam Says:

    Thank you for posting!

    This was very helpful!

  6. Eyeball Says:

    I am lost at step 6. Where did Table2 come from? How did you get that value there? Totally confused on how you got that in there. Help!

All Product Types Accessories Cars Digital Camcorders Digital Cameras eReaders GPS Laptops MP3 & Video Players Projectors Smartphones Software Storage Tablets / MIDs VoIP Wi-Fi
All Subcategories
All Subcategories All-Purpose Budget Business Desktop Replacement Gaming Multimedia Netbook Nettop Rugged Student Tablet PCs Ultraportable
Acer Alienware Apple Archos ASUS Averatec BenQ CTL Corp. Dell Digital Storm eMachines Emtec Everex Fujitsu GammaTech Gateway General Dynamics Getac Gigabyte Hercules HP HTC iBuyPower Intel Lenovo MSI Nokia Nvidia OCZ OLPC OQO Origin Panasonic Sager Samsung Sony Sylvania Systemax TabletKiosk Toshiba Verizon Viewsonic Viliv VooDoo Workhorse PC ZT Systems
Minimum Rating
Any Rating 4.5 Stars 4.0 Stars 3.5 Stars 3.0 Stars
Screen Size
10 11 12 13 14 15 16 17 18 20 4 5 6 7 8 9
1024x576 1024x600 1024x768 1200X800 1280 x 720 1280x1024 1280x768 1280x800 1366x678 1366x768 1440x1050 1440x900 1600x768 1600x900 1680x1050 1680x945 1920x1080 1920x1200 800x400 800x480
Weight Range
10.1 - 12.0 pounds 12.1 - 14.0 pounds 14.1 - 16.0 pounds 2 lbs 2 pounds and under 2+ lbs 2.1 - 4.0 pounds 4.1 - 6.0 pounds 6.1 - 8.0 pounds 8.1 - 10.0 pounds Over 16 pounds Under 2 pounds
more options