Excel Function: MATCH() Explained

Excel MATCH function examples allow us to see how the MATCH function can be used, and understand what scenarios it could help us. Basically, the MATCH function was designed to return a relative row reference (relative to the array in which data is searched for) for data that you specify. If searching for a number, […]

Read More

How to Flag Multiple Matches In Your VLOOKUP Formula?

This article will explore the Excel VLOOKUP Formula and show you how to combine it with an IF statement to flag if there are multiple lookup values matches in your data set. VLOOKUP is really great for pulling in data from a larger table in Excel, but sometimes in a larger data sets there may […]

Read More

Excel Formula : SUMPRODUCT () for Advanced Users

When I first learned about the SUMPRODUCT  formula  in  Excel , I almost dismissed it as a useless  formula  used by only few users. How often would anyone need to multiply 2 or more groups of numbers together and add up the results!? To get to the story, we know that formula is keyed in as: […]

Read More

9 Tips to Write Lookup Formulas More Effectively – Excel Tip

It is not breaking news, but something that anyone working on an Excel Report using formulas and functions, will know the keys of successfully using lookup formulas. They are vital for making almost any spreadsheet or dashboard. That is why when you learn how to extract information from Excel tables, you will be truly excited, […]

Read More

How to VLOOKUP with Multiple Criteria in Multiple Column

VLOOKUP is definetly a great tool to get the data from tables, however it has limitations: it can only work with one criteria for matching information. What If you need to refer two or more conditions to match a specific piece of data, VLOOKUP will only get the first match in the data. Fortunately Excel has functions called INDEX and MATCH that works same as VLOOKUP but with multiple criteria. Here’s a quick tutorial to help you learn how…

Read More