Browse » Home
Wednesday, January 11, 2012
How do I Use VLookup in MS Excel?
1. Type '=VLOOKUP(' into the cell in that you want the result of this function to be displayed. Don't include the quotation marks.
2. Type in the value that you want the function to look for, followed by a comma. You can either type it in as a literal value. If it is text, make sure to enclose it in quotation marks. You can enter a cell reference.The function will search for whatever value is contained in the cell you refer to.
3. Enter the cell reference for the range of cells comprising the table, followed by another comma. For example, if your table consists of cells A1 through E10, enter in A1:E10. Alternatively, you can just click and drag a box around the table, and Excel will automatically put the cell reference into the formula. The function will search for the value you entered in step two in the first column of this range, so make sure the range you enter begins with the correct column.
4. Type in a number representing the column you want to get your result from, followed by another comma. For example, if you want the telephone number from the third column of the range you entered in Step three, type in 3. The number refers to columns in the range, not the column numbers in the spreadsheet. The first column, the column used to find the key value, is column 1.
5. Type TRUE or FALSE, followed by a closing parenthesis ')', then push Enter. You should use FALSE if you want the function to only find an exact match to your key value, or TRUE if want to let it find the nearest approximation.