VLOOKUP Function

VLOOKUP Partial Text from a Single Cell in Excel

Today I will be showing how you can use VLOOKUP to search for partial text in Excel. One of the most important and widely used functions of Excel ...

VLOOKUP To Compare Two Lists in Excel (2 or More Ways)

Performing a comparison between a couple of lists is one of the familiar tasks in Excel. Today we are going to show how to compare two lists using ...

How to Use VLOOKUP with COUNTIF (3 Ways)

VLOOKUP and COUNTIF are mostly used and powerful functions in MS Excel. VLOOKUP is used to find any specific data from any table and the COUNTIF ...

VLOOKUP with Two Lookup Values in Excel (2 Approaches)

Depending on circumstances you may need to use multiple lookup values with VLOOKUP. For easing your effort, today we are going to show you how to use ...

VLOOKUP Formula in Excel with Multiple Sheets (4 Simple Tips)

Today I will be showing how to use the VLOOKUP formula across multiple sheets in Excel. One of the most important and widely used functions of ...

How to Return the Highest Value Using VLOOKUP in Excel

The VLOOKUP function is one of the most useful and at the same time one of the most sophisticated functions in Excel. This function not only helps ...

How to Use VLOOKUP for Multiple Columns in Excel

Today I will talk about MS Excel’s popular and highly used function name VLOOKUP. This function can be used to extract, compare, shift, or search ...

Combining SUMPRODUCT and VLOOKUP in Excel (2 Examples)

In Excel, you may need to use different sum family functions: SUM, SUMIF, SUMPRODUCT, and so on. Depending on circumstances, it’s quite common to ...

INDEX MATCH across Multiple Sheets in Excel (With Alternative)

In Microsoft Excel, it’s a common scenario to lookup and then extract data from multiple sheets based on different criteria. The combination of INDEX ...

VLOOKUP from Another Sheet in Excel

When you have to deal with massive data from multiple worksheets across your Excel workbook, the VLOOKUP function is your savior. The VLOOKUP ...

VLOOKUP with 2 Conditions

In Excel, you may need to search values using different lookup functions: LOOKUP, VLOOKUP, HLOOKUP. Today we are going to show you how to use VLOOKUP ...

VLOOKUP Max of Multiple Values (With Alternative)

MS Excel’s VLOOKUP function is used when we need to find things in a table or in a range by row. It makes our task easy in terms of searching for ...

Auto Sort When Data is Entered in Excel (3 Methods)

Sorting data automatically in excel is really useful when you are handling a wide range of data. Excel has no definite tool to auto-sort your data. ...

Find Matches or Duplicate Values in Excel (8 Ways)

In Microsoft Excel, there are several suitable methods to find matches or duplicate values with formulas or VBA. You can extract data based on the ...

How to Use VLOOKUP If Cell Contains a Word within Text in Excel

In Microsoft Excel, sometimes we have to look for different types of data related to a specific word or information within the text in a cell from ...

ExcelDemy
Logo