VLOOKUP Excel Archives

How to Use VLOOKUP Function with Exact Match in Excel

May 18, 2023

While working on big datasets of big companies, educational institutions, and financial organizations like banks, it is required to find particular ...

How to Use VLOOKUP Function with Exact Match in Excel

How to Use LARGE Function with VLOOKUP Function in Excel

May 20, 2023 2

Today we will discuss how we can use the LARGE function with the VLOOKUP function in Excel. The LARGE function returns the n-th largest value of a ...

How to Use LARGE Function with VLOOKUP Function in Excel

How to Use Named Range in Excel VLOOKUP Function

Apr 17, 2023

The VLOOKUP function is one the most commonly used functions in Microsoft Excel. We use the VLOOKUP function to find values in a table to extract ...

How to Use Named Range in Excel VLOOKUP Function

Excel VLOOKUP Exercises: 10 Tricky Problems

May 11, 2023 2

In this article, you will get ten Excel VLOOKUP exercises to practice. Most of the problems are easy to solve. However, you will need a little bit of ...

Excel VLOOKUP Exercises: 10 Tricky Problems

How to Calculate Annual Leave in Excel (with Detailed Steps)

Mar 22, 2023 2

When an employee works in an organization, he earns some leaves based on criteria. Leave is an essential part of corporate or job life. We can track ...

How to Calculate Annual Leave in Excel (with Detailed Steps)

How to Apply Double VLOOKUP in Excel (4 Quick Ways)

Feb 8, 2023

In this article, we will discuss how to apply Double VLOOKUP in Excel. Basically, we use the VLOOKUP function to get faster results in Excel. ...

How to Apply Double VLOOKUP in Excel (4 Quick Ways)

VLOOKUP Not Working (8 Reasons & Solutions)

Feb 14, 2023 2

VLOOKUP is one of the most common and useful functions. As it is widely used so many people have complaints about not working VLOOKUP correctly or ...

VLOOKUP Not Working (8 Reasons & Solutions)

Excel LOOKUP vs VLOOKUP: With 3 Examples

Feb 12, 2023

We use Both Excel LOOKUP and VLOOKUP functions to lookup values in datasets to bring out values from desired column and range. Though LOOKUP and ...

Excel LOOKUP vs VLOOKUP: With 3 Examples

What Is Table Array in Excel VLOOKUP?

Feb 9, 2023

The Table Array is one of the required arguments in the VLOOKUP function in Microsoft Excel. The VLOOKUP function searches for a certain value within ...

Why VLOOKUP Returns #N/A When Match Exists (with Solutions)

Feb 9, 2023

We use the VLOOKUP (Vertical Lookup) function to search for a value vertically in a column and then return a corresponding value from another column. ...

Why VLOOKUP Returns #N/A When Match Exists (with Solutions)

INDEX MATCH vs VLOOKUP Function (9 Practical Examples)

Feb 7, 2023

In this article, you will get 9 practical examples of the INDEX MATCH vs VLOOKUP function. Excel provides various functions to look up a value in a ...

INDEX MATCH vs VLOOKUP Function (9 Practical Examples)

How to Use Nested VLOOKUP in Excel (3 Criteria)

Feb 13, 2023

The VLOOKUP function is one of Microsoft Excel’s most powerful, flexible, and extremely useful functions to search and retrieve values – either ...

How to Use Nested VLOOKUP in Excel (3 Criteria)

Use VLOOKUP with Multiple Criteria in Excel (6 Methods + Alternatives)

May 8, 2023

If you have worked with Microsoft Excel for a while, you know how functional the VLOOKUP function is. We can search for an element from a large ...

Use VLOOKUP with Multiple Criteria in Excel (6 Methods + Alternatives)

How to Use VLOOKUP Function in Excel VBA (4 Examples)

Feb 9, 2023

In this article, I’ll show you how you can use the VLOOKUP function of Excel in VBA. You’ll learn to use the VLOOKUP function with a user-defined ...

How to Use VLOOKUP Function in Excel VBA (4 Examples)

Wildcard with VLOOKUP in Excel (6 Examples)

Feb 9, 2023

Excel is one of the most widely used software applications in our life. We use Excel to make data more meaningful and usable. In this article, we ...