INDEX and MATCH with multiple criteria in Excel
This lesson will support you in performing complex two-way lookups with ease. We’ll explore the mechanics of the two-way lookup using the combination of INDEX and MATCH functions. The INDEX function will help us retrieve the sales value from the specified array, while the MATCH function will allow u...
| Autor Corporativo: | |
|---|---|
| Formato: | Video |
| Idioma: | Inglés |
| Publicado: |
[Place of publication not identified] :
Assemble You
2024.
|
| Edición: | [First edition] |
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009825893006719 |
| Sumario: | This lesson will support you in performing complex two-way lookups with ease. We’ll explore the mechanics of the two-way lookup using the combination of INDEX and MATCH functions. The INDEX function will help us retrieve the sales value from the specified array, while the MATCH function will allow us to find the positions of the selected company and month within their respective lists. Combining these functions makes our formula flexible enough to handle various combinations, ensuring accurate and efficient data retrieval. |
|---|---|
| Descripción Física: | 1 online resource (1 video file (5 min.)) : sound, color |
