Latest Blog Posts - Page 373 of 412

INDIRECT Function with Sheet Name in Excel (4 Practical Uses)

May 20, 2024

Method 1 - INDIRECT Function with Sheet Name to Refer Another Worksheet In the example image below, Sheet1 contains the names of donors and the ...

INDIRECT Function with Sheet Name in Excel (4 Practical Uses)

How to Use VALUE Function in Excel (5 Ideal Examples)

Jul 14, 2024

In this article we will demonstrate how to use Excel's VALUE function to convert various types of data into numbers. Here is an overview: ...

How to Use VALUE Function in Excel (5 Ideal Examples)

How to Reference Worksheet Name in Formula in Excel

Jun 24, 2024

Let’s consider the Sales Data for January in the “January” worksheet, which depicts the “Product Name” and the “Sales” in USD. We have the ...

How to Reference Worksheet Name in Formula in Excel

How to Use INDIRECT, INDEX, and MATCH Functions in Excel

May 15, 2024

Method 1 – Using the INDIRECT Function in a Table Steps: Select cell C15. Enter the following formula: ...

How to Use INDIRECT, INDEX, and MATCH Functions in Excel

VLOOKUP and Return All Matches in Excel (7 Ways)

Jul 3, 2024

Method 1 - VLOOKUP and Return Multiple Matches in a Column We have a table containing random names of several employees and their departments. We ...

VLOOKUP and Return All Matches in Excel (7 Ways)

How to Create a Drop Down List from Another Sheet in Excel

Jul 5, 2024

This tutorial will demonstrate how to create a drop-down list from another sheet in Excel, and also from multiple sheets. Example 1 - ...

Using Excel VBA to Find a Value in a Column – 6 Examples

Aug 4, 2024

The sample dataset contains Product ID, Brand, Model, Unit Price, and Order ID. You want to find an Order ID associated with a Product ID. ...

Using Excel VBA to Find a Value in a Column – 6 Examples

How to Make a Drop Down List in Excel (Independent and Dependent)

Jul 31, 2024

Example 1 - Create an Independent Drop-Down List in Excel We have a list of popular Samsung smartphones. We’ll make a drop-down list in Cell E7 from ...

How to Make a Drop Down List in Excel (Independent and Dependent)

VLOOKUP with Numbers in Excel (4 Examples)

Aug 2, 2024

The VLOOKUP function is generally used to look for a value in the leftmost column in a table and return a value in the same row from another ...

VLOOKUP with Numbers in Excel (4 Examples)

XLOOKUP vs INDEX-MATCH in Excel (All Possible Comparisons)

Jun 30, 2024

Introduction to the XLOOKUP Function The XLOOKUP function finds a specific value within a range of cells or an array. It then returns the ...

XLOOKUP vs INDEX-MATCH in Excel (All Possible Comparisons)

INDEX MATCH Formula with Multiple Criteria in Different Sheet

Jul 9, 2024

Method 1 - INDEX-MATCH Formula with Multiple Criteria for Columns Only We'll use a Monthly Sales Report of a particular organization, containing the ...

INDEX MATCH Formula with Multiple Criteria in Different Sheet

How to Use CHOOSE Function in Excel?

Jul 3, 2024

Below is an overview of our sample dataset. Example 1 - Using CHOOSE Function to Get Data from Selected Range The CHOOSE function will ...

Use Excel VBA VLOOKUP to Find Values in Another Worksheet

Jul 8, 2024

In this article, we will demonstrate how to use the Excel VBA VLOOKUP in another worksheet. Suppose we have the dataset below, stored in the sheet ...

Use Excel VBA VLOOKUP to Find Values in Another Worksheet

How to Use VLOOKUP for Rows in Excel (With Alternatives)

May 30, 2024

Method 1 - Use the MATCH function to Define a Column Number from Rows in VLOOKUP In the following picture, a dataset is presented with the amounts ...

How to Use VLOOKUP for Rows in Excel (With Alternatives)

XLOOKUP vs VLOOKUP in Excel (Comparative Analysis)

Aug 2, 2024

Basics of XLOOKUP and VLOOKUP in Excel XLOOKUP Function The XLOOKUP function searches a range or an array for a match and returns the ...