VLOOKUP FORMULA IN MS EXCEL

 The VLOOKUP function in MS Excel is used to look up and retrieve data from a specific column of a table or range of cells. Here are the steps to use VLOOKUP in MS Excel:

1. First, select the cell where you want to place the result of the VLOOKUP function.

2. Type the formula "=VLOOKUP(" in the selected cell.

3. In the parentheses, enter the lookup value you want to search for.

4. After the lookup value, enter a comma and then the range of cells you want to search in. Make sure the first column of this range contains the lookup value.

5. Enter another comma and then the column number of the cell you want to retrieve data from.

6. Finally, close the parentheses and press Enter.

For example, suppose you have a table of student grades and you want to look up the grade of a student with the ID "123". The table is in cells A1:B5, with column A containing the student IDs and column B containing their grades. To use VLOOKUP to retrieve the grade of student 123, you would enter the formula "=VLOOKUP(123,A1:B5,2,FALSE)" in the cell where you want to display the result. This will search for the ID 123 in column A of the range A1:B5 and retrieve the corresponding grade from column B.

Note that the "FALSE" argument at the end of the formula indicates that you want an exact match for the lookup value. If you want an approximate match, you can use "TRUE" instead. You can also use 0 & 1 respectively.