Excel Functions

[Fixed!] Excel VLOOKUP Drag Down Not Working (11 Possible Solutions)

VLOOKUP is a widely used function in Excel to extract a column of data from one sheet to another. It usually looks for a value in the dataset and ...

How to Use VLOOKUP to Find a Value Within a Range

To demonstrate how to use VLOOKUP to find a value within a range, we'll use the following dataset, which contains information about some Employees - ...

Transfer Data from One Excel Worksheet to Another Automatically with VLOOKUP

If you are looking for ways to transfer data from one Excel worksheet to another automatically with VLOOKUP, then this article will be helpful for ...

How to Use Multiple IF Condition in Excel (3 Examples)

In this tutorial, we will demonstrate different examples of how to use multiple IF condition in excel. However, we may need to analyze multiple ...

How to Trim Part of Text in Excel (9 Easy Methods)

While working in Microsoft Excel, you may need to trim part of a text string. For example, you might require removing a certain part of a text ...

How to Add Dashes to SSN in Excel (6 Methods)

Microsoft Excel offers multiple ways to add dashes to social security numbers (SSNs). You can use formulas or the Format Cells dialog box to add ...

How to Use VLOOKUP Table Array Based on Cell Value in Excel

This article will provide you with 4 methods on how to use the VLOOKUP table array based on cell value in Excel. If we want to extract some ...

Vlookup with Multiple Criteria without a Helper Column in Excel (5 Ways)

Introducing helper columns to vertically lookup data always brings complexity. It also manipulates the raw data as additional data columns are ...

FIND Function Not Working in Excel (4 Reasons with Solutions)

In this tutorial, we will explain the reasons for the problem of why the FIND function in excel is not working. In Microsoft Excel, the FIND function ...

Create Drop-Down List Using INDIRECT Function in Excel

This article illustrates how to use the INDIRECT Function in Excel to create a drop-down list easily. You will also learn how to create a dependent ...

Perform VLOOKUP by Using Column Index Number from Another Sheet

The VLOOKUP function is used to look up values in a database. In most cases, we are used to applying the VLOOKUP function in the same sheet. However, ...

How to Convert Text to Formula Using the INDIRECT Function in Excel

Introduction to the INDIRECT Function in Excel We can use  the INDIRECT function to get a valid cell reference from a cell value that is stored as a ...

How to SUMIF between Two Dates and with Another Criteria (7 Ways)

If you are looking for some of the easiest ways to SUMIF between two dates and another criteria, then you will find this article useful. Adding up ...

How to Use COUNTIF with Multiple Criteria in the Same Column in Excel

While working with a large Microsoft Excel, sometimes we need to count cells with multiple criteria. In our Excel worksheet for the convenience of ...

How to Calculate Working Days between Two Dates in Excel (4 Methods)

In this tutorial, we will explain how to use different functions to calculate working days between two dates in Excel. Sometimes, it becomes very ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo