Tweet
Formula for VLOOKUP
Clicking the VLOOKUP option will open a new window. In the Lookup_Value box, enter the cell reference from the first column. You can either type the formula manually or select the cell you wish to choose using your mouse. Once selected, press the F4 key to make your formula absolute – this is important to ensure there are no errors once a search is performed.
In the Table_array box, either type or use the mouse to select the contents of the field you wish VLOOKUP to search. Again, press F4 to make the formula absolute.
The col-index-num box requires you to enter the number of the column you wish VLOOKUP to retrieve data from. In this case, VLOOKUP will be retrieving data from the second column.
The range_lookup box requires you to enter either true or false. Entering true tells VLOOKUP to find the closest match, while typing false forces VLOOKUP to find an exact match.
Once all the information has been entered, click OK to complete the formula. Now, you can enter information into the pre-selected search cell and VLOOKUP will provide a match from the range of data selected. Be sure to stick to items in the selection range, though!
Clicking the VLOOKUP option will open a new window. In the Lookup_Value box, enter the cell reference from the first column. You can either type the formula manually or select the cell you wish to choose using your mouse. Once selected, press the F4 key to make your formula absolute – this is important to ensure there are no errors once a search is performed.
In the Table_array box, either type or use the mouse to select the contents of the field you wish VLOOKUP to search. Again, press F4 to make the formula absolute.
The col-index-num box requires you to enter the number of the column you wish VLOOKUP to retrieve data from. In this case, VLOOKUP will be retrieving data from the second column.
The range_lookup box requires you to enter either true or false. Entering true tells VLOOKUP to find the closest match, while typing false forces VLOOKUP to find an exact match.
Once all the information has been entered, click OK to complete the formula. Now, you can enter information into the pre-selected search cell and VLOOKUP will provide a match from the range of data selected. Be sure to stick to items in the selection range, though!