Excel functions

Before we begin, make sure to download the left lookup example file below: If you’ve ever used Excel’s VLOOKUP function, you’ve probably run into one of its biggest limitations—it can’t …

Filtering by column in Excel is a quick way to display only the data you need while hiding the rest. It helps you focus, analyze, and work faster—especially when dealing …

If you haven’t yet, you’ll soon come across a situation through your journey with excel, where you’ll want to manipulate text by changing the case, I mean capitalization. In this …

What is MATCH function in Excel? The MATCH function is used to search for a value in a range in order to retrieve the position of a cell that matches …

If you are reading this, I guess you already know how the VLOOKUP function works. This function is so sensitive that it can detect even trailing and leading spaces in …

What is a double lookup in Excel? Two-way lookup or double lookup is simply a formula that looks in both vertical and horizontal directions simultaneously, in order to find a …

VLOOKUP is one of the popular functions in Excel. It is very helpful to many Excel users who want to look and retrieve information from a table (or dataset). As …

The built-in Excel data entry form is ideal for data entry tasks. It shines when you need to enter data that has been arranged in rows. It is a time …

In this step by step tutorials, you’ll learn how to use the INDEX function in Excel, with a clear syntax breakdown and examples demystified. What is INDEX function in Excel? …

Want to know why your Excel VLOOKUP is not working? You are in the right place. This tutorial will help you learn why you are getting VLOOKUP errors in Excel …