Excel INDEX Function Tips
Looking Up Number Values
There are five methods you can use to look up number values in excel. These include SUMPRODUCT, SUMIF, AGGREGATE, LOOKUP and a combination of INDEX & MATCH.
Using Index-Match Combination To Ease Up Lookup Process
Most of the time when we are stuck with lookup and return something process, we revert to VLOOKUP() and occasionally HLOOKUP(), according to the situation
Generating Random Data In 5 Minutes
When we are developing a model or trying to test some formula, we need data and when we don’t have one, we have to create it to suit our needs. This is frequently called dummy data.
Latest
-
Understanding How HYPERLINK Works In Excel
Excel has a built in function to create hyperlinks &...
-
Understanding how MS Excel Query Works
“Query” in MS Excel has same meaning as ...
-
An Introduction To Excel Power Map
Our today’s post is about “Power Map&rdq...
-
Using Pivot Charts For Displaying Data
Conventional charts are mostly used for displaying r...
-
Using “Calculated Items” For Analyzing A Pivot Table
In our last post, we explored how to use calculated ...
