Yesterday, one of my colleagues, who is really passionate to learn Excel these days asked me “do you know how to remove first character from a cell? I told him […]
Yesterday, when one of my subscribers ask me for help about her problem which she was facing. All she needed was to combine SUMPRODUCT IF Functions to get data from a table. She was trying hard to create a formula but unfortunately she was unable to sort out her problem. While solving her problem I have learned a new thing to create SUMPRODUCT IF Statement.
In this post, I’ll reveal the secret about how I use VLOOKUP And MATCH to create data for my Dynamic Charts. I’ll also tell you about reasons to use VLOOKUP And MATCH to increase the power of VLOOKUP. But before doing this let me explain you everything about the combination of these two awesome functions.