VLOOKUP is my first love of Excel, it is great function to get the corresponding values from a table easily, however there is situation where we might want to get the cell color and font color along with lookup value. VLOOKUP is a function which will return only values, but not the cell formats. Thankfully Excel allows […]
Articles Tagged: Excel Formulas
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, […]
Excel Formula Vs Function : What is the difference?
Once question I get asked about a LOT it when it comes to Excel is just what is the difference between a Function and a Formula? In this article I will discuss the differences and work through some examples. A Formula in Excel can be described as a statement that is written by a spreadsheet […]
Excel Tip : How to Generate Unique Usernames using the IF() and COUNTIF() Functions
Today let’s learn how to generate unique usernames in Excel, even when you have duplicates in your data. Formulas Used 1) IF( condition, [value_if_true], [value_if_false] ) Learn More about IF() Parameters or Arguments condition The value that you want to test. value_if_true Optional. It is the value that is returned if condition evaluates to TRUE. […]
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 […]
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: […]
Excel Formula : SEARCH() vs FIND()
There are two very similar functions in Excel to look for data inside of cells matching parameters that you dictate: SEARCH and FIND. There are so similar, in fact, that one wonders why have two separate functions that perform virtually the identical results and are identical in the construct of the formula. This article will […]
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, […]
3 Ways To Enter An Excel Formula
Today let’s look at 3 different ways to enter formulas into your Excel workbooks. Do you use the same method over and over again?. you may find a quicker method… read on with me. Let’s look at an example where want to find the Total Costs which we want to display in Column F, which […]
5 Tips for Data Manipulation in Excel
There’s plenty you can do, if you know the correct formulas. There’s a lot of data munging you can do in a plain old Excel spreadsheet — if you know how to craft the proper formulas.