Professor Excel
3d, 3 way, lookups, 3d lookups, excel

3D Lookups in Excel: 6 Methods (+Download)

The king of lookups in Excel: The 3 way- or 3D lookup. Imagine this scenario: You got several Excel tables, each has rows and columns. Depending on your input values, you want to get the data from a specific cell from the right table, row and column. Such lookups are called 3D lookups or 3 way lookups. In this article we explore 6 methods of how to conduct 3D lookups in Excel.

[…]

countifs, excel, countif

COUNTIFS in Excel: Everything You Need to Know

The COUNTIFS function works similar like the SUMIFS function. But instead of adding up the values, it counts how many items with one or more criteria are in your table.

2D Lookups in Excel: 4 Easy Methods for 2 Way Lookups + Excel Download

There are many cases in which you need a 2 dimensional lookup. That means, if you want to get a value from a specific row-column combination with neither rows or columns fixed. Unfortunately, the problem of a two way lookup comes up quite often. In this article we explore 4 methods of how to conduct 2D lookups in Excel.

[…]

hlookup, excel, eagle, look, search, lookup, vlookup

HLOOKUP in Excel: Everything you need to know

You’ve probably heard of VLOOKUP which is a very popular and powerful formula in Excel. Far less known is the little brother: HLOOKUP. It basically works the same way as VLOOKUP with one difference: Instead of looking up values vertically, HLOOKUP works horizontally. In this article, you learn how to use HLOOKUP, what to keep in mind, possible error messages and some more advices about HLOOKUP.  […]

vlookup, hlookup, lookup, excel, how, guide

VLOOKUP in Excel: All You Need to Know About the Powerful Formula

One of the most popular formulas in Excel is the VLOOKUP formula. Many lookup approaches are based on the VLOOKUP formula. Mastering it is crucial for any of the following chapters and methods. Unfortunately, VLOOKUP is not as easy to use as a SUM or COUNT. In this article, you learn how to use VLOOKUP, what to keep in mind and some more advices about VLOOKUP.
[…]

File Name, Sheet Name or Path: Insert File Information into Excel Cell

There are many cases, in which you want to show the sheet name or file name in an Excel cell. Don’t worry, you don’t have to use VBA and create a macro. Excel provides a (rough) formula for returning all the information you need. The bad news: In most cases it takes some complex modifications. The good news: Usually you can just copy and paste the formula you need.

[…]

if, iferror, ifna, ifs, thumbnail

IF Formula in Excel: Everything You Need to Know

The IF formula is one of the most useful formulas in Excel. It is highly adjustable and can be extended by other formulas easily. But many Excel users don’t really know all it’s secrets. Do you know how to use it? This article covers everything you need to know about it: How to use it, how to extend it and how to use the related formulas IFNA, IFERROR and the new formula IFS. […]

space, remove, blank, cell, excel

Space Character: Remove Last Letter in Excel If It Is Blank

Does this situation sound familiar to you: You compare texts in Excel and they should be equal. But instead, Excel says the two cells are not the same. Oftentimes, there is a hidden space in the end of a text cell. Very troublesome: You can’t really see it because the blank character is at the end of the text. In this article we explore 4 methods of how to remove the last character of a text in Excel if it is a space. 

[…]

sumifs, excel, tutorial

SUMIFS in Excel: Everything You Need to Know (+Download)

The SUMIFS formula adds up all numbers, when one or more than one criterion is fulfilled. SUMIFS only exists since Excel 2007 and is especially useful, as it can regard several search criteria.

round, roundup, rounddown, excel

ROUND: How to Round Values in Excel

Today we talk about a basic topic in Excel: Rounding numbers. Excel provides three different versions of formulas for rounding number: ROUND, ROUNDUP and ROUNDDOWN. ROUNDUP and ROUNDDOWN always round numbers away or towards zero. In this article we take a closer look at the ROUND formula and explore advanced ways of applying it.

[…]