Explanation
VLOOKUP searches for a value in the first column of a table and returns a value from another column in the same row.
Syntax
=VLOOKUP(lookup_value,table_array,col_index_num,[range_lookup])
Arguments
|
Argument |
Meaning |
|
lookup_value |
Value you want to find |
|
table_array |
Lookup table |
|
col_index_num |
Column number to return |
|
range_lookup |
TRUE for approximate, FALSE for exact |
Example
|
Product ID |
Product |
Price |
|
P101 |
Keyboard |
800 |
|
P102 |
Mouse |
500 |
|
P103 |
Monitor |
8500 |
|
P104 |
Printer |
12000 |
Suppose E2 contains:
P103
Formula:
=VLOOKUP(E2,A2:C5,2,FALSE)
Result:
Monitor
Price:
=VLOOKUP(E2,A2:C5,3,FALSE)
Result:
8500
Important Point
For an exact lookup, use:
FALSE
Practice
Create a Product Lookup sheet where entering a Product ID automatically returns:
- Product Name
- Price