Excel Functions: What is new? Can I use this function?

When I create Excel files for my clients, one of my first questions is “Which Excel version do you use?”. The reason for this question is that I want to know which formulas and functions of Excel I can use and will work on my clients computer. For example: Can I use the more special… Continue reading Excel Functions: What is new? Can I use this function?

XLOOKUP, VLOOKUP or INDEX/MATCH? Big Lookup Functions Guide!

One of the most often used functions when creating an Excel model is consolidating data from different sources. Traditionally, there were 3 major functions for combining data from different tables or worksheets: VLOOKUP, SUMIFS and INDEX/MATCH. Now, Microsoft has introduced XLOOKUP. So what is the difference between these four lookup functions and which one should… Continue reading XLOOKUP, VLOOKUP or INDEX/MATCH? Big Lookup Functions Guide!

How to Return the Font Color From Excel Cell

You have received an Excel file and somebody has highlighted text with a different font color? If you are talking about a few cells only – no problem. But what, if you file has hundreds of rows? How do you return the fore color from the text (or number) cells? Method 1: Do it manually… Continue reading How to Return the Font Color From Excel Cell

How to Return the Background Color Code From Excel Cell

Let’s assume the following situation: You have received an Excel file and someone has highlighted different cells. Now you want to read out the different background color codes in order to convert the file into a proper Excel data table. Unfortunately, there is no direct built-in way to solve this. So, let’s see how to… Continue reading How to Return the Background Color Code From Excel Cell

How to bulk insert IFERROR to existing Excel formulas!

We have already explored the IFERROR function in Excel. IFERROR (and IFNA) provide great ways to catch errors in Excel formulas and functions. Now, let’s take it to the next level: Bulk insert IFERROR and IFNA to existing functions. That means, you have many functions already and just want to wrap IFERROR or IFNA around… Continue reading How to bulk insert IFERROR to existing Excel formulas!