How to Do a VLOOKUP in Excel - Video Tutorial



Community Tested

Why choose wikiHow?
When you see the green checkmark on a wikiHow article, you know that the article has received careful review. In this case, we tested the instructions on our own devices and confirmed that the instructions worked.

How to Use Vlookup With an Excel Spreadsheet

This wikiHow teaches you how to find a cell's corresponding information in Microsoft Excel using the VLOOKUP formula. The VLOOKUP formula is useful for finding things like employee salary values or your budget on a given date. You can use VLOOKUP in both Windows and Mac versions of Excel.

Steps

  1. Open your Excel document.Double-click the Excel document that contains the data for which you want to use the VLOOKUP function.
    • If you haven't yet created your document, open Excel, clickBlank workbook(Windows only), and enter your data by column.
  2. Make sure that your data is properly formatted.VLOOKUP only works with data that's organized in columns (e.g., in vertical sections), meaning that your data most likely has headers in the top row of cells but not in the far-left column of cells.
    • If your data is organized by rows instead, you'll won't be able to use VLOOKUP to find a value.
  3. Understand each aspect of the VLOOKUP formula.The VLOOKUP formula consists of four main parts, each of which refers to a piece of information in your spreadsheet:
    • Lookup Value- The cell across from which the data that you want to look up is in. For example, if you want to look up data in cellF3, your lookup value will be in the third row of the spreadsheet.
    • Table Array- Your entire table's span from the top-left cell to the bottom-right cell (not including headers). For example, if your table starts atA2, goes down toA20, and extends over to theFcolumn, your table goes fromA2toF20.
    • Column Index Number- The index number of the column in which the value that you want to look up is in. A column's "index number" refers to its order number; for example, in a spreadsheet that has data in columnsA,B, andC, the index number ofAwould be 1,Bwould be 2, andCwould be 3. The index number starts at 1 for the far-left column of data, so if your data starts in columnF, its index number is 1.
    • Range Lookup- You'll normally want a precise answer for the VLOOKUP result, which can be achieved by typing inFALSEfor this value. For an estimate, you can type inTRUEinstead.
  4. Select an empty cell.Click a cell in which you want to store the result of the VLOOKUP formula.
  5. Add the VLOOKUP formula tag.Type in=VLOOKUP(to start the VLOOKUP formula. The rest of the formula will go between the open parenthesis and a closed one at the end.
  6. Enter the lookup value.Find the cell in which the lookup value is written, then enter the cell's name into the VLOOKUP formula followed by a comma.
    • For example, if the lookup value is written in cellA12, you'd typeA12,into the formula.
    • You'll separate each section of the formula with a comma, but you don't need to use spaces.
  7. Enter the table array value.Find the top-left cell in which data is stored and enter its name into the formula, type a colon (:), find the bottom-right cell in the data group and add it to the formula, and then type a comma.
    • For example, if your table goes from cellA2to cellC20, you'd typeA2:C20,into the VLOOKUP formula.
  8. Enter the column index number.Find the index number of the column that contains the value that you want VLOOKUP to display, then type it into the formula with a comma after it.
    • For example, if your table uses theA,B, andCcolumns and the data that you want is inC, you would type in3,here.
  9. Type inFALSE)to close the formula.This will allow VLOOKUP to find the exact value in your specified column for the selected item. Your formula should look something like this:
    • =VLOOKUP(A12,A2:C20,3,FALSE)
  10. PressEnter.Doing so will run your formula and display the result in the formula's cell.

Community Q&A

Search
  • Question
    How do I find repetitive information?
    wikiHow Contributor
    Community Answer
    Use Conditional Formatting under the Home Tab in Excel. You can highlight duplicates. It is also possible to downright remove duplicates using another function under the Data Tab
    Thanks!
  • Question
    What is excel coding?
    wikiHow Contributor
    Community Answer
    Excel uses VBA. To access this, you need to edit your ribbon banner and select the "Developer" option to be added to your ribbon. This is typically used for things like Macros.
    Thanks!
  • Question
    Can I put Vlookup formula for 5 raw data in one command?
    NurtureTech Academy
    Community Answer
    Yes, you can get 5 raw data on a single command with array function. For example; Vlookup (A1,A1:F5,{2,3,4,5,6},0) after than do not hit enter you have to press ctrl+shift+enter.
    Thanks!
Unanswered Questions
  • How can I add data vertically on one sheet but have it update horizontally on another?
  • How do I amend v look up formulas in excel?
Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
  • A common application of VLOOKUP for an inventory sheet entails plugging an item's name into the "lookup value" section and using the item's cost column as the "column index number" value.
  • To keep the cell value from changing in your VLOOKUP code when you add or adjust cells in your table, put a '$' before each letter and number of each cell name. For example,A12would become$A, andA2:C20would become$A:$C.

Warnings

  • Double-check your column index number before plugging it into the VLOOKUP formula, as the column index number changes depending on which column your data starts in—not the order of the columns themselves.

Related wikiHows

Sources and Citations

Article Info

Featured Article

Categories: |

In other languages:

Português: , Italiano: , Español: , 中文: , Deutsch: , Русский: , Français: , Bahasa Indonesia: , Nederlands: , العربية: 

Thanks to all authors for creating a page that has been read 315,651 times.





Video: How to do a Vlookup in Excel - Learn how in 5 minutes!

How to Use Vlookup With an Excel Spreadsheet
How to Use Vlookup With an Excel Spreadsheet images

2019 year
2019 year - How to Use Vlookup With an Excel Spreadsheet pictures

How to Use Vlookup With an Excel Spreadsheet recommendations
How to Use Vlookup With an Excel Spreadsheet advise photo

How to Use Vlookup With an Excel Spreadsheet photo
How to Use Vlookup With an Excel Spreadsheet photo

How to Use Vlookup With an Excel Spreadsheet How to Use Vlookup With an Excel Spreadsheet new pictures
How to Use Vlookup With an Excel Spreadsheet new pictures

photo How to Use Vlookup With an Excel Spreadsheet
pics How to Use Vlookup With an Excel Spreadsheet

Watch How to Use Vlookup With an Excel Spreadsheet video
Watch How to Use Vlookup With an Excel Spreadsheet video

Discussion on this topic: How to Use Vlookup With an Excel , how-to-use-vlookup-with-an-excel/
Forum on this topic: How to Use Vlookup With an Excel , how-to-use-vlookup-with-an-excel/ , how-to-use-vlookup-with-an-excel/

Related News


In the Aisle: Pineapple
Daily Deal: Finally, A Standing Desk You Can Actually Afford
5 Ways To Wear Tartan
How to Do Leg Workout Rehabilitation for Knee Pain
Chocolate Afternoon Tea at Chancery Court Hotel, London
Men’s Fashion Basics – Part 75 – The Posh Do
How to Check Your Blood Pressure with a Sphygmomanometer
How to get out of a choke hold
Uniqlo Denim: SS15 Collection
TheLIST: Whats In: Modern Art
La styler ghd che fa del bene
Benefit Cosmetics Lip Kits Eye Kits That Are As Good Kylie’s Kits
Struggle With a Feline Flick Maybe Its Because Youre Using the Wrong Eyeliner
Enbrel Reviews
10 Signs Youre Dating a Dog Person



Date: 16.12.2018, 13:36 / Views: 74365