Excel Functions Archives - Page 21 of 40

How to Apply a Double VLOOKUP in Excel

Jul 27, 2024

Introduction to the Excel VLOOKUP Function The VLOOKUP function is a powerful tool in Excel that allows you to search for a value in the leftmost ...

How to Use Excel EXACT Function (6 Suitable Examples)

Aug 4, 2024

The Excel EXACT function tests two text strings and returns TRUE or FALSE depending on their exact match or otherwise respectively. The EXACT ...

How to Use Excel EXACT Function (6 Suitable Examples)

How to Use DAYS Function in Excel (5 Suitable Examples)

Jul 15, 2024

Example 1 - Using Excel DAYS Function to Get Estimated Time To estimate the total number of days needed to complete the project Steamy Ray from its ...

How to Use DAYS Function in Excel (5 Suitable Examples)

How to Use FIXED Function in Excel (6 Suitable Examples)

Nov 11, 2025

The FIXED function is a built-in function in Microsoft Excel. It is categorized as a String/Text Function. It is one commonly used procedure in ...

How to Use FIXED Function in Excel (6 Suitable Examples)

How to Use TIME Function in Excel (8 Suitable Examples)

Nov 11, 2025

The TIME function is a built-in function in Excel that is categorized as a Date/Time Function. TIME function of Microsoft Excel is one of the ...

How to Use TIME Function in Excel (8 Suitable Examples)

How to Use TYPE Function in Excel (8 Examples)

Nov 11, 2025

The TYPE function in Excel will return an integer number based on the type of data that you are entering. In this article, you will be able to know ...

How to Use TYPE Function in Excel (8 Examples)

VLOOKUP Not Working (8 Reasons & Solutions)

May 25, 2024

Although VLOOKUP has some limitations, the reason why VLOOKUP is not working is usually human error. To demonstrate the possible issues and their ...

VLOOKUP Not Working (8 Reasons & Solutions)

Excel LOOKUP vs VLOOKUP: With 3 Examples

Jul 4, 2024

Method 1 - Dealing with Approximate Match One of the main differences between LOOKUP and VLOOKUP functions is that the LOOKUP function is bound to ...

Excel LOOKUP vs VLOOKUP: With 3 Examples

How to Use MEDIAN Function in Excel (4 Suitable Examples)

Nov 11, 2025

While working in Excel, we may need to find the median value in a range of data that actually reflects the median level of the dataset. We can ...

How to Use MEDIAN Function in Excel (4 Suitable Examples)

How to Use LOOKUP Function in Excel?

Jul 29, 2024

Here's an overview of the article, which represents a simplified application of the LOOKUP function in Excel. You’ll learn more about the dataset as ...

How to Use AVERAGEA Function in Excel (10 Examples)

Nov 11, 2025

In Excel, the AVERAGEA function works to get the average value of any kind of given data type, whether numeric values or text or boolean, AVERAGEA ...

How to Use AVERAGEA Function in Excel (10 Examples)

What Is Table Array in Excel VLOOKUP?

Aug 1, 2024

What Is Table Array Argument in VLOOKUP Function? The Table Array argument in the Excel VLOOKUP function is used to find and look up the desired ...

How to Use Excel IFNA Function (5 Suitable Examples)

Nov 11, 2025

Excel IFNA function is primarily used to handle the #N/A errors. It returns a specific value as per your instruction if such a #N/A error occurs; ...

How to Use Excel IFNA Function (5 Suitable Examples)

How to Use the CLEAN Function in Excel – 10 Examples

Aug 11, 2024

This is an overview. CLEAN Function in Excel Function Objective The CLEAN function removes all non-printable characters from a text. ...

How to Use the CLEAN Function in Excel – 10 Examples

How to Add Characters in Excel (with Formula, Flash Fill & VBA)

Jul 8, 2024

Here's an overview of a method where characters are added using Flash Fill. Download the Practice Workbook Add Characters.xlsm ...