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