Business analysis glossary
VLOOKUP and XLOOKUP
What it is
VLOOKUP and XLOOKUP are spreadsheet functions that find a value in one table and return a related value from the same row, for example looking up a product code to return its price. XLOOKUP is the newer, more flexible version that can look in any direction and handles missing values more clearly.
Why it matters
Analysts constantly combine data from different exports, such as matching an order list to customer details. Lookups do this quickly and are one of the most tested Excel skills in BA interviews in India. Knowing their pitfalls, such as approximate matches and missing keys, prevents wrong results.
Example
The analyst has a list of failed deliveries with PIN codes and a separate list of PIN codes with courier zones. She uses XLOOKUP to add the zone to each failed delivery, then a pivot table shows that most failures come from two rural zones handled by one courier partner.