How to vlookup
How to do a Vlookup in Excel
Do you have hundreds of rows of data that need to be sorted accurately and immediately? Then learning how to VLOOKUP can literally save you hours of work!
Be proficient in using VLOOKUP function in minutes with these simple tutorial which works in all versions of Excel and Google Sheets. Save hours of analysis and finish your work early. Follow these 5 steps on how to VLOOKUP within minutes.
STEP 1 First, click into a cell where you want the VLOOKUP result to appear.
STEP 2 Click on the ‘fx’ button above the column of the cell you clicked in Step 1. The Insert Function dialog will appear. In the Search for a function: text box, type “vlookup” and click Go. Highlight VLOOKUP and click OK and the function arguments window will pop-up.
STEP 3 Add the VLOOKUP syntax tag. Type in =VLOOKUP( to start the VLOOKUP syntax. The rest of the syntax will go between the open parenthesis and a closed one at the end.
STEP 4 Find the cell in which the lookup value is written, then enter the cell’s name into the VLOOKUP syntax followed by a comma.
VLOOKUP Function Arguments
• Lookup_value – is the corresponding value from the first table which we want to find in the particular column of the second table.
• Table_array – is the entire table’s span from the top-left cell to the bottom-right cell (not including headers) which has the corresponding numbers that the lookup value is looking.
• Col_index_num – is the number of the column on your lookup table that has the information you need.
• Range_lookup – defines how close a match should exist between your Lookup_value and the value in the leftmost column on our lookup table. In most cases, using the word “FALSE” will allow VLOOKUP to find the exact value in your specified column for the selected item
STEP 5 After you have entered the necessary values for the VLOOKUP syntax, type in FALSE) to close the formula.
Now all you have to do is drag down the formula, so that the cells below populate, and you save yourself the hassle of manually finding the corresponding value for each and every cells in the first table.
video by Excel Stuff