Excel Functions Archives - Page 14 of 40

Vlookup with Multiple Criteria without a Helper Column in Excel: 5 Methods

May 25, 2024

Method 1 - Combine the VLOOKUP and CHOOSE Functions to Vlookup with Multiple Criteria in Excel ❶ Select cell G9 first. ❷ Then insert the ...

Vlookup with Multiple Criteria without a Helper Column in Excel: 5 Methods

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

Jul 10, 2024

Overview of the FIND Function Description The FIND function is used to locate a particular character or substring inside a text string ...

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

Create a Drop-down List Using the INDIRECT Function in Excel – 2 Methods

Aug 13, 2024

This is an overview. The Excel INDIRECT Function Objective: Create a reference from a text string. References created will not change ...

Create a Drop-down List Using the INDIRECT Function in Excel – 2 Methods

How to Use VLOOKUP with a Column Index Number to Find Values from Another Sheet (2 Methods)

Jul 10, 2024

Dataset Overview In the screenshot below, you’ll find a sample dataset that we’ll use to demonstrate the two methods. Syntax of the ...

How to Use VLOOKUP with a Column Index Number to Find Values from Another Sheet (2 Methods)

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

Apr 30, 2024

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 Convert Text to Formula Using the INDIRECT Function in Excel

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

Jun 20, 2024

The following dataset contains sales records of some products, their estimated delivery dates, and company selling regions. Using this dataset, we ...

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

How to Find Last Business Day of Month in Excel (9 Handy Ways)

Nov 11, 2025

This article illustrates how to find the last business day of a month in Excel. It also shows how to find the last business day/workday in any year. ...

How to Find Last Business Day of Month in Excel (9 Handy Ways)

How to Use COUNTIF with Multiple Criteria in the Same Column in Excel (5 Methods)

Jul 6, 2024

We have a dataset that contains information about several projects. The project names, managers of those projects, and estimated costs of those ...

How to Use COUNTIF with Multiple Criteria in the Same Column in Excel (5 Methods)

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

Jun 2, 2024

Method 1 - Use the Excel NETWORKDAYS Function to Calculate Working Days Between Two Dates Case 1.1 - Calculate Working Days Between Two Dates ...

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

How to Use VLOOKUP Function on Multiple Rows in Excel

Jul 3, 2024

Looking for ways to use the VLOOKUP function on multiple rows in Excel? Do not worry, we are here for you. In this article, we will extensively ...

How to Use VLOOKUP Function on Multiple Rows in Excel

How to Calculate Bacterial Growth Rate in Excel: 2 Easy Methods

Jul 6, 2024

Method 1 - Using an Exponential Formula to Calculate Bacterial Growth Rate in Excel Bacteria in cultures follow exponential growth. From ...

How to Calculate Bacterial Growth Rate in Excel: 2 Easy Methods

How to Find the Second Match with VLOOKUP in Excel (2 Methods)

Jul 21, 2024

Dataset Overview We'll use a sample dataset that represents the Salesman, Product, and Net Sales of a company. Introduction to Excel ...

How to Find the Second Match with VLOOKUP in Excel (2 Methods)

How to Apply VLOOKUP by Date in Excel

Aug 2, 2024

The following picture gives an idea of how VLOOKUP by date works. Apply VLOOKUP by Date in Excel We are going to use the following ...

How to Remove Vlookup Formula in Excel (6 Methods)

May 29, 2024

We will use the following dataset to explain how you can remove a VLOOKUP formula from a cell or table. Method 1 - Use Ribbon Options to ...

How to Remove Vlookup Formula in Excel (6 Methods)

How to Use the VLOOKUP Function to Find an Approximate Match for a Text in Excel – 4 Examples

Aug 7, 2024

This is the syntax of the VLOOKUP function: VLOOKUP (lookup_value, table_array, column_index_num, ) The fourth argument (range_lookup) ...