Excel Functions

How to Apply the Advanced Uses of the CHOOSE Function in Excel (9 Applications)

Introduction to Excel CHOOSE Function The CHOOSE function requires two arguments: index_num and value1, along with optional additional values. ...

VLOOKUP with Multiple Criteria and Multiple Results: 8 Examples

Method 1 - Using the Ampersand Operator to VLOOKUP with Multiple Criteria Steps: Create a column to represent both criteria in the same column. ...

How to Use CHAR(10) Function in Excel (3 Practical Examples)

  Below is a dataset on the Bill Report of ABC Company. The dataset has three columns: Customer ID, Name, and Status. Penny's status is ...

[Fixed!] CHAR(10) Is Not Working in Excel (3 Solutions)

One of the most widely used applications in our day-to-day lives is the spreadsheet application Microsoft Excel. Excel was created solely with the ...

Character Codes for CHAR Function in Excel (5 Common Uses)

Looking for a way to use Excel character codes for the CHAR function? Don’t worry, you have come to the right place. In this article, I will show you ...

How to Vlookup and Return Multiple Values in a Drop Down List – 2 Methods

Method 1 - Vlookup Multiple Values Combining the INDEX, MATCH & ROW Functions Steps This is the sample dataset.. To create a ...

How to Use CHAR(34) Formula in Excel (2 Examples)

Introduction to The CHAR Function Summary The CHAR function returns a character specified by a code number from your computer’s character set. ...

How to Use CHAR(32) Formula in Excel (5 Practical Examples)

The article will show you an application of the CHAR function in Excel. Suppose you have a range of IDs in the dataset and you want a space in the ...

How to Vlookup a Partial Match for the First 5 Characters in Excel

Why Should We Use VLOOKUP Function for Partial Match? The VLOOKUP function fetches data from one table to another when the lookup value matches the ...

How to Convert Excel ASCII to Char

American Standard Code for Information Interchange (ASCII) is a character encoding standard for electronic devices. In its 7-bit version, it supports ...

How to Apply VLOOKUP with Multiple Criteria Using the CHOOSE Function

While working in Excel, we often need to find a value by applying the VLOOKUP function with multiple criteria using the CHOOSE function. VLOOKUP ...

How to Return Cell Address Instead of Value in Excel (5 Ways)

While applying the Excel formula, we frequently use the cell address or cell reference to return a cell value. But if you work on an Excel sheet of a ...

COUNTIFS Function in Excel with Multiple Criteria from Different Sheet

Sometimes you may need to use the COUNTIFS function with multiple criteria from a different sheet in Excel. So, if you are looking for the use of a ...

Excel COUNTIFS with Multiple Criteria Including Not Blank

Like the COUNTIF function, the COUNTIFS function counts the number where specified conditions are true. The difference between them is mainly that ...

How to Use Cell Address in Excel Formula (8 Suitable Examples)

To perform calculations and retrieve data based on the values in specific cells, you must know how to use a cell address in Excel Formula. However, ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo