ExcelDemy - Page 2 of 53 - Free Excel Tutorial & Online Courses

How to Create a Drop Down List From Another Sheet in Excel (2 Methods)

Sep 23, 2021 Excel Basics

When you are working with a large database and you need to pick a specific item from a list, a drop-down list can help you in this situation. Using a ...

How to Use IF ISNA Function with VLOOKUP in Excel

Sep 23, 2021 Excel Formulas

One of the most important and widely used functions of Excel is VLOOKUP. But while using VLOOKUP, we may sometimes face errors when the lookup value ...

How to Find Value in Column Using VBA in Excel (4 Ways)

Sep 23, 2021 Excel Functions

In MS Excel we frequently need to search or find values in the dataset. It could be finding data in the rows or the column. Fortunately, Excel ...

How to Edit Drop-Down List in Excel (4 Basic Approaches)

Sep 23, 2021 Excel Basics

In Excel, a drop-down list is a helpful feature to fill the right data in a field (cell or column) swiftly. Once you build the drop-down list you ...

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

Sep 23, 2021 Excel Basics

When analyzing large amounts of data, the use of drop-down lists streamlines the experience. And you can make this drop-down list within a minute in ...

VLOOKUP with Numbers in Excel (4 Examples)

Sep 23, 2021 Excel Formulas

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

XLOOKUP vs INDEX-MATCH in Excel

Sep 23, 2021 Excel Formulas

In the earlier versions of Excel, we used to use the HLOOKUP, the VLOOKUP, and the INDEX-MATCH functions of Excel to look for a specific value in a ...

How to Use INDEX MATCH with Multiple Criteria in a Different Sheet (2 Ways)

Sep 23, 2021 Excel Formulas

You may sometimes find yourself in a situation When you are working with a large array of data, and you need to find some unique values or texts but ...

How to Use CHOOSE Function in Excel (4 Ways)

Sep 23, 2021 Excel Functions

MS Excel’s CHOOSE function returns a value from a list using a given position or index. The values provided to CHOOSE can be hard-coded constants or ...

Use of VLOOKUP in VBA to Find Values from Another Worksheet in Excel

Sep 23, 2021 Excel Formulas

Circumstances may arise when you need to use certain VBA codes that execute the operation from different worksheets, like you may need to use VLOOKUP ...

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

Sep 23, 2021 Excel Formulas

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

XLOOKUP vs VLOOKUP in Excel (Comparative Analysis)

Sep 23, 2021 Excel Formulas

In Microsoft Excel, you might be well aware of the VLOOKUP function whereas the addition of the XLOOKUP function in Excel 365 has a greater ...

How to Use VLOOKUP in VBA (4 Ways)

Sep 23, 2021 Excel Formulas

In terms of searching or seeing some specific values or elements, MS Excel provides various functions. VLOOKUP is one of them. It helps us to search ...

VLOOKUP to Find Duplicates in Two Columns

Sep 23, 2021 Excel Formulas

You may need to compare two columns in Excel to find duplicates or unique. In this article, we are going to show you how to find duplicates from two ...

VLOOKUP with Multiple Matches in Excel

Sep 23, 2021 Excel Formulas

One of the most amazing and widely used functions of Excel is VLOOKUP. So far we have learned to pull out a single match from a range of cells using ...

Latest Posts