Explanation
Lookup functions search for a value in a table or range and return related information.
Important Functions
|
Function |
Purpose |
|
VLOOKUP |
Searches vertically and returns a related value |
|
HLOOKUP |
Searches horizontally |
|
XLOOKUP |
Modern and flexible lookup function |
|
LOOKUP |
Performs approximate lookup |
|
INDEX |
Returns a value from a specified position |
|
MATCH |
Finds the position of a value |
|
XMATCH |
Modern version of MATCH |
|
CHOOSE |
Returns a value from a list based on position |
|
ROW |
Returns row number |
|
COLUMN |
Returns column number |
|
ROWS |
Counts rows in a range |
|
COLUMNS |
Counts columns in a range |
Basic Lookup Concept
Suppose we have:
|
Product ID |
Product |
Price |
|
P101 |
Keyboard |
800 |
|
P102 |
Mouse |
500 |
|
P103 |
Monitor |
8500 |
|
P104 |
Printer |
12000 |
If the user enters P103, Excel can automatically return:
Monitor — ₹8,500
Practice
Create a Product Master table and manually identify the product and price for different Product IDs.