3 years ago
Abacum VLOOKUP
Abacum VLOOKUP is here! 🚀
How does it work?
Imagine having the following datasets and you want to bring the department dimension to the Location dataset:
1. Employees, with employee id and department as dimensions.
2. LOCATIONS, with employee id and region as dimensions.
| EMPLOYEES | ||
|---|---|---|
| date | employee_id | department |
| 08/01/2023 | 1234 | Finance |
| 08/01/2023 | 5678 | Technology |
| LOCATIONS | ||
|---|---|---|
| date | employee_id | region |
| 08/01/2023 | 1234 | Spain |
| 08/01/2023 | 5678 | USA |
Formula: VLOOKUP department FROM EMPLOYEES on employee_id = employee_id