30/04/2020
Use the VLOOKUP function in Microsoft Excel to find related Data in your worksheet
The VLOOKUP function in Microsoft Excel is a great way to find relational data.
For example:- you have a busy worksheet with a lot of data points and you want to know the name of a supplier and the corresponding supplier's specific phone number.
There are four necessary pieces of information that you need to know first before you use the VLOOKUP function
— including the lookup value
— the range of where the value is located
— the column number (not letter) it's in, and
— whether you want an exact or approximate match.
STEPS:
1. Open Microsoft Excel.
2. Open a saved worksheet, or enter your data into a new worksheet before continuing.
3. Select the cell where you want to execute your VLOOKUP formula. It should be blank, so your VLOOKUP result doesn't overwrite anything. for example, we'll use cell D4.
4. At the menu at the top, select "Formulas."
5. Select "Lookup & Reference."
6. Scroll down and select VLOOKUP from the drop-down menu.
7. A pop-up screen will then appear on the right where you'll enter your data fields. First, enter the value you're looking for. It can be anything from a name, number, or cell address.
8. Now you will enter where Excel should search for the data — this can be two or more columns, creating a range on the lookup table. Remember: VLOOKUP searches for data vertically, so be sure to enter the column letter followed by the row number. For this example, we want to search through all the data, encompassing all fields on the worksheet, for example we'll enter "A2:B16."
9. Next, Excel wants you to enter the "column number in the range that contains the return value" — this data point should be where you want the data to come from. In our example, phone numbers are represented in column B, so we would enter the numerical value of B, which is two (it's the second column).
10. Finally, enter whether you want the results to be approximate (1) or exact (0). We want our results to be spot on so we will write 0. All together our formula looks like this:=VLOOKUP("D1",A2:B16,2,0).
11. Select "Ok" or "Done" at the bottom of the formula window.
12. The value will then appear in the cell you selected at the beginning.
For any doubts do call to us on 0671 2879769
or write to us [email protected]
Happy Learning......😃
