Excel Sheet VLOOKUP Formula

Excel Sheet VLOOKUP formula is a beneficial formula where you look a specific and target condition of data related to the condition. If you a thousand of record and to want a code data past another cell VLOOKUP is best for this condition.

Another word if you related to Databases like MSSQL, Oracle, MySql, and another database Vlookup work is same to 'where' clause in Excel Sheet.

Below we have a record of data and find a specific code Type of data.

We have data two columns in the above Txn Code and Txn Type where we want Txn Type from the following code. How we find the specific Code data we use a VLOOKUP formula. The Data Row number 2 and 150-row number.

VLOOKUP Formula:

This is VLOOKUP Formula for use in the specific data search. How to use the formula in the following data. If we have data where we find the data Txn Type of data.

Here you see in above image how we search data through VLOOKUP Formula? We have Data Code, Code Type, and the third column data code which one we search this column data.

We describe the following Parameter of Formula what are these? Now you see the formula is 

=VLOOKUP(J3,$D$3:$E$150,2,FALSE)

The first Parameter is J3 (J is Column name), 3 is Row number which above image mention him.

The second Parameter is $D$3:$E$150 here D is column name and 3 is a row $D$3 starts Point number of code which matches your condition another is $E$150, E is a column name and 150 is a row of the column which at end of the row of column E.

The Third Parameter is 2 which you want a column name what is required to your condition TXN Type.

The fourth Parameter is FALSE means is exactly match the code to your condition code. there is a show to two option to in this parameter one True which means is not exactly matched your condition another is False.

Click the Enter Button you get the result of your code.

Here is get the final Result of your code you search the result which you want. Hopefully, you understand and enjoyed this tutorial. How VLOOKUP formula is used fully us in excel.