VLOOKUP PROJECT

 

PPROJECT BY MRS. BLESSING, SUCCESS AND ABRAHAM

VLOOKUP is a powerful function in Excel that searches for a value in the first column of a range (table or array) and returns a corresponding value in the same row from a specified column. The "V" in VLOOKUP stands for "Vertical," indicating that it searches vertically (downward) in a table.

VLOOKUP: Searches for a value in the first Colum of a table and returns a value in the same row from another Colum. to use it, type = Vlookup (“followed by the value to search for, the range of the table, the Colum number to return the value from, and the FALSE for an exact match. The “V” in vlookup stands for ‘’vertical’’, 

Indicating that it searches vertically (downward) in a table.

                                 How to write a VLOOKUP formula            

To write the VLOOKUP formula in cell F2, follow these steps:

1.     Type =VLOOKUP(

2.     Use cell E2 as the lookup value

3.     Select the range of cells B5:F17 which defines the table where the data is stored (the table array argument)

4.     Insert 5 as the col_index_number argument as we are looking to retrieve data from the 5th column from our table

5.     Choose Exact match for the match_type parameter. Remember, this corresponds to FALSE in our formula.

6.     Type ) and then press Enter to complete the VLOOKUP formula.

THE USE OF VLOOKUP FUNCTION SYNTAX & ARGUMENTS

There are four possible parts of this function:

=VLOOKUP (search value, lookup table, column number, [approximate match] )

• Search value is the value you're searching for. It must be in the first column of lookup table.
• Lookup table is the range you're searching within. This includes search value.
• Column number is the number that represents how many columns into lookup table, from the left, should be the column that VLOOKUP returns the value from.
• Approximate match is optional and can be either TRUE or FALSE. It determines whether to find an exact match or an approximate match. When omitted, the default is TRUE, meaning it will find an approximate match.

 How to use VLOOKUP function in Excel

The first questions I hear from people are “how does VLOOKUP work?” and “how to do VLOOKUP?” The function retrieves a lookup value from a table array by matching the criteria in the first column. The lookup columns (the columns from where we want to retrieve data) must be placed to the right.

How to use Vlookup Formula

          I know that we have given you a formula before, but VLOOKUP have different formula so, this is the second one:

1)    Select a cell  ( F3 )

2)    Type (=VLOOKUP)

3)    Double Click the vlookup command

4)    Select the cell where search value will be entered ( B3 )

5)    Types(   ,   )

6)    Mark table range ( B2:D10 )

7)    Types(   ,   )

8)    Type the number of the column, counted from the left (  2  )

9)    Type true (  1  )

10)   Hit enter.

Let have a look at an example use the Vlookup. Function to find the Pokémon names based on their Id#:

STEP 1

STEP 2

STEP 3

STEP 4

STEP 5

T

he VLOOKUP function also has an optional fourth argument: range lookup. This can be either TRUE or FALSE. If the range lookup argument is FALSE, VLOOKUP will find only exact matches. If the range lookup argument is TRUE, or if a range lookup argument is not entered, VLOOKUP can find approximate matches. In this case, the lookup table must be sorted in ascending order by the first column in it; otherwise VLOOKUP may not return the correct value.

If the range lookup argument is TRUE or omitted and the lookup value does not appear in the first column of the lookup table, but falls between two values in it, Excel will use the lower of the two values. If the lookup value is smaller than any value in the first column of the lookup table, Excel returns an error message.

        The lookup value is the value for which you want to find matching data and must appear in the first column of the lookup table, it can be a value, a text string or a call reference.

           They use of vlookup when you need to find anything in a table or a range by row. For example vlookup a price of an automotive part by the part number, or find an employee name based on their employee ID  

 THANK YOU FOR READING.s