Excel Functions Archives - Page 18 of 29

10 Best Practices with VLOOKUP in Excel

Jun 21, 2024

Introduction to the VLOOKUP Function Function Objective: The VLOOKUP function is used to look for a given value in the leftmost ...

IF and VLOOKUP Nested Function in Excel: 5 Practical Uses and 2 Ways of Handling Errors

Jun 16, 2024

Practical Uses 1. How to Match VLOOKUP Output with a Specific Value Let’s say we want to determine how much inventory we have for a particular ...

IF and VLOOKUP Nested Function in Excel: 5 Practical Uses and 2 Ways of Handling Errors

How to Use VLOOKUP to Find Partial Text from a Single Cell

Jul 5, 2024

We have a data set with the Names, Authors, and Book Types of some books from a bookshop named Martinez Bookstore. We'll look for a partial text ...

How to Use VLOOKUP to Find Partial Text from a Single Cell

How to Use VLOOKUP Function to Compare Two Lists in Excel

May 28, 2024

Here we have a dataset of equipment lists for two gyms. We will compare the lists using the VLOOKUP function. Method 1 - Compare Two Lists ...

How to Use VLOOKUP Function to Compare Two Lists in Excel

How to Use VLOOKUP with COUNTIF (3 Easy Ways)

Jul 3, 2024

Example 1 - Count the Occurrences Using VLOOKUP and COUNTIF Functions Let’s consider a dataset of student attendance over a week (based on student ...

How to Use VLOOKUP with COUNTIF (3 Easy Ways)

How to Use VLOOKUP with Two Lookup Values in Excel

Jul 3, 2024

We have a table containing the roll of honor for the few major European football leagues. Using this dataset, we will VLOOKUP with two lookup values. ...

How to Use VLOOKUP with Two Lookup Values in Excel

How to Use VLOOKUP Formula in Excel with Multiple Sheets

May 21, 2024

An Introduction to Excel’s VLOOKUP Function =VLOOKUP(lookup_value,table_array,col_index_num,) This function takes a range of cells called ...

How to Use VLOOKUP Formula in Excel with Multiple Sheets

Return the Highest Value Using VLOOKUP Function in Excel

Jun 14, 2024

Introduction to VLOOKUP Function The VLOOKUP function looks for a value in the left-most column of a table array and then returns a value in ...

Return the Highest Value Using VLOOKUP Function in Excel

How to Use VLOOKUP for Multiple Columns in Excel?

Apr 12, 2024

Method 1 - Getting Values from Multiple Columns Using Excel VLOOKUP Function Consider the following starting dataset, containing Product ...

How to Use VLOOKUP for Multiple Columns in Excel?

How To Combine SUMPRODUCT and VLOOKUP Functions in Excel (2 Examples)

Jul 24, 2024

Understanding the Scenario Let’s start with a basic example. Imagine we have a table with product names and their revenues over five months. We want ...

How To Combine SUMPRODUCT and VLOOKUP Functions in Excel (2 Examples)

How to Find Minimum Value Based on Multiple Criteria in Excel

Jun 11, 2024

Method 1 - Find the Minimum Value Based on Multiple Criteria Using MIN and IF Functions Let’s assume we have a food order dataset with their product ...

How to Find Minimum Value Based on Multiple Criteria in Excel

VLOOKUP to Return Multiple Values Horizontally in Excel: 2 Methods

Jul 5, 2024

Method 1 - Use of INDEX, SMALL, and IF Functions to VLOOKUP and Return Corresponding Values Horizontally Step 1: ➤ The required formula in cell ...

VLOOKUP to Return Multiple Values Horizontally in Excel: 2 Methods

Find the Max of Multiple Values by Using the VLOOKUP Function in Excel – 2 Methods

Aug 8, 2024

Method 1 - Combining the VLOOKUP and the MAX Functions to Find the Max of Multiple Values This is the sample dataset. Steps: Enter the ...

Find the Max of Multiple Values by Using the VLOOKUP Function in Excel – 2 Methods

How to Sort by Date in Excel: 9 Suitable Methods

Jul 6, 2024

Method 1 - Applying Sort & Filter Feature to Sort by Date in Excel Steps: Select the whole data set by selecting cells B4:D19. Go to the ...

How to Sort by Date in Excel: 9 Suitable Methods

How to Copy Formula Down with Shortcut in Excel

Jun 24, 2024

Method 1 - Using Keyboard Shortcut to Copy Formula Down for a Column in Excel Steps: Choose a cell (D7) and press CTRL+SHIFT+END to select all ...