Answer:
It’s the short form of vertical lookup. Click on the cell where you would like to place the Vlookup formula. Now click on the formula over at the top of your screen. Now click on Lookup and references which is part of the ribbon, and click on the Vlookup which is at the bottom part of the drop-down menu that appears.
Now specify the cell. Where you require the value, the data related to which are going to look for through the formula. Now specify data that you would like to lookup in the table array box. You can select the entire table excluding the headers. Now you need to specify the column number that Vlookup will be using to for finding the pertinent data. You need to use the numerical value of the column and not the letter value. Like for column C, its 3. Now you need to mention whether you need the exact match. It can be true for exact and false for approximate match. Now click on OK which is at the bottom part of the window that has popped up.
With the help of the VLookup, you can search for various individual results. However, you can combine various worksheets as well through Vlookup function, and thus, you can do the mining of the whole workbook to leave out the required information at the cell where you want the information to be show. An Example is like VLOOKUP(40, A4:D15, 2)
Explanation:
The answer covers all. However, please remember we have HLookup as well as Xlookup. Xlookup is a new entry to this list. And all these are one of the best and most powerful functions for data mining using the Excel sheet.
