VLOOKUP Function

How to Swap Columns and Rows in Excel (9 Easy Ways)

Are you struggling with analyzing or viewing a complex Excel dataset? If so, swapping the columns and rows in your Excel spreadsheet might be the ...

Excel Reference Named Range in Another Sheet (3 Examples)

Excel's named range is a powerful tool that allows users to refer to a specific range of cells by a name rather than a cell address. This feature ...

How to Use VLOOKUP Function with Exact Match in Excel

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

How to Use Named Range in Excel VLOOKUP Function

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 Perform Bank Reconciliation Using VLOOKUP in Excel

Accountants always have to do reconciliations in their daily job. It helps to observe and maintain equality in both-sided transaction ledgers. One of ...

How to Create Shipping Cost Calculator in Excel (with Easy Steps)

Fortunately, many of us use Excel in our business organisations. In any business organisation, we use Excel to organise data as per need. Moreover, ...

How to Use Implicit Intersection Operator in Excel (4 Examples)

Sometimes you may need to use an implicit intersection operator in Excel. In this article, I will show you how, and where to use an implicit ...

How to Use IF with ISNA Function in Excel (3 Ideal Examples)

While working with Excel, we often face #N/A error when the required value is missing from the dataset. But if you want to get rid of this visible ...

How to Find Largest Lookup Value in Excel (3 Easy Ways)

In this article, we will demonstrate 3 handy ways to find the largest lookup value using the combination of the VLOOKUP function with other functions ...

How to Create Bill Book in Excel (2 Easy Ways)

Book Bill contains information regarding the purchased products and shows the overall bill. Likewise, businessmen need to create bill books for their ...

How to Calculate Commission in Excel Using IF Function

The Calculation of commission is one of the basic tasks of Excel applications for a long period of time. Calculating commission based on the sales ...

Intersection of Two Columns in Excel (7 Easy Methods)

While working in Microsoft Excel sometimes we need to find intersection of two columns. But sometimes it becomes difficult if you are not aware of ...

How to Create Social Security Break Even Calculator in Excel

Social security is the benefit given to the citizen by the US government. In this article, we will discuss this social security scheme and the ...

How to Use Multiple IFERROR Statements in Excel (2 Smart Ways)

Microsoft Excel is a powerful tool for organizing and analyzing data, but sometimes our data isn't always clean and error-free. That's where the ...

How to Perform Left Outer Join in Excel (2 Easy Methods)

This tutorial will demonstrate how to perform left outer join in Excel. When we are dealing with many data tables that represent information about a ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo