## Lookup Multiple Fields of Data with Excel VLOOKUP

With the combination of Excel VLOOKUP function with the Column, Column and array function you can easily create a lookup formula which allows you to quickly lookup multiple fields of data with Excel VLookup function. Excel VLookup function with array or column function easily return multiple values from a single row of a database or array of table. Read More

## How to use VLookup Match function in Excel

VLookup Match one of the most powerful and important function in Excel. Sometime we need to use VLookup and Match function together to lookup specific value. If you need better control over during lookup and match the value then you must have to know how to use VLookup Match function in Excel. Read More

## How to use Double VLookup in Excel

If you have data in two different table or worksheet then you need to apply double VLookup in Excel. At this situation most the Excel user face lot of issue how to get the exact result which match the condition. This article helps you to know how to use Excel Double VLookup function in active worksheet. Read More

## Excel VLookup Find First, 2nd Or Nth Match Value in Excel?

If you have more than one columns and want to use Excel VLookup Find First, 2nd Or Nth Match Value. Normally it’s not easy to do this job but after reading this article you can easily find out first, 2nd or Nth match value in Excel sheet. All we know VLookup is a powerful lookup function which is located in lookup and reference category. Read More

## VLookup to return multiple column values

VLookup is an important Lookup and Reference function which allows you to prepare different types of MIS reports. You can use VLookup to return multiple column values at once without any extra effort. During using the VLookup function you must have to again and again type VLookup function to view next column values. But after reading this trick you can quickly view rest of columns values which is based on the lookup value with the help of VLookup function. Read More

## How to use VLookup and Sum function to get total for Multiple columns

Most of the person want to become an Excel expert and they need more practice on different functions. In this guide we have to discuss how to use VLookup and SUM function to get the total for multiple columns in Excel sheet. During preparing the MIS reports you must have to use VLookup function to search the specific value. Read More

## How to use Advance Backward VLookup in Reverse Order in Excel

All we know VLookup function is used for search values from left to right side in given array or table. But sometime we need to lookup any value in reverse order. In that situation you need to know how to use advance backward VLookup in reverse order in Excel? In this guide we have to discuss solution to use reverse VLookup in Excel. Read More

## Advanced VLookup trick with Data Validation in Excel

VLookup is an important lookup function which allows you to lookup specified value as per the given condition. Data validation allows you to apply different set of rules on selected range of cells. In this guide we have to discuss advanced VLookup trick with Data Validation in Excel. You can use VLookup function along with Data Validation to solve complex condition and get the exact result. Read More