How To Use VLOOKUP in Excel

Utilize VLOOKUP in Excel

If you want to Use VLOOKUP in Excel spreadsheet, then you need to follow the procedure provided below:

Step 1. Open your Excel Workbook, or excel spreadsheet on your computer and then open your excel file.

Step 2. After that, select the cells in which you want to utilize VLOOKUP formula to be calculated in your excel.

Step 3. Then, move your cursor towards the “Formula” tab available on the menu thread of the excel sheet.

Step 4. After that, you need to select the “Lookup & Reference” option from the ribbon.

Step 5. This will open the drop-down list, and you need to choose the “VLOOKUP” option showing on the bottom of the list.

Step 6. In LOOKUP Value, you need to put the value of that cell whose data you want to get. You need to choose the column of a table in order to get the value.

Step 7. After that, on the “Table Array” option, you need to select the table where you want to get the value of complete data.

Step 8. Note:the First column of the table array will be compared to selected ‘Lookup Value’. So select it in the right way to get the right result.

Step 9. For this, you need to click on the sheet number 2 and then select the entire table to retrieve value.

Step 10. On the “Col_Index_num” option, you need to enter the number of columns of comprehensive data and then enter “False” in the range lookup option to get the exact result.

Step 11. If you write True in the“Col_Index_num” box then it means you will get approximate match by default.

Step 12. At last, you need to hit the “OK” button appearing on the bottom of the pop-up window.

Step 13. After this, you will get the average range lookup in that cell where you select the VLOOK UP.

Step 14. Through this, you will get the complete data by using VLOOKUP in your excel.