In this article we will talk about the INDEX and MATCH formulas, which are two useful lookup functions when others (such as VLOOKUP) reach their limits. Do you like examples? I do, let’s be practical: Example The report below, which I know it’s very complicated, hard to understand (not). We see that the Sales box is empty, […]