# Match-Function

## How to lookup images in Excel using Index Match function

Sometime we need to lookup images in Excel sheet. There are lot of Excel functions which allows you to lookup values in Excel sheet. But in case of lookup the image there is different procedure. In this guide we discuss how could you easily lookup images in Excel. Read More

## How to use the Match function in Excel

he MATCH function in Excel allows you to quickly locate for a specified item in range of cells, and then returns the relative position of that item in the range. Match Excel Function is used to returns the relative position of an item in the given array or range of cells that match a specific value in specific order. You can easily use match function to get the result either in vertical or horizontal lookup array. Read More

## Triple VLookup with Index Match function in Excel

Sometime we need to apply triple VLookup in active worksheet and want to get the result which fulfil all given three criteria. In that situation you must have to use Index Match function at the place of applying VLookup function in active worksheet. In this article we have to discussion how could you easily apply triple VLookup with Index Match function in active worksheet. 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 apply multiple criteria using match function in Excel

Match function in Excel allows you to search for a value in an array and return the relative position of the item in specific order. Sometime you need to apply more than one criteria in that case you can use Match function in Excel. Excel Match function is an important function which is located in Lookup and Reference category. 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

## How to use index and match functions for advanced lookup in Excel

Hi, today we are talking on Index and Match most popular and powerful function in Microsoft Excel. You can use index match function in excel separately or with combination of other functions as per your need. In this guide we have to discuss how to use index and match functions for advanced lookup in Excel. Index and Match and VLookup functions found in the Lookup and Reference category.  Read More

## How to compare data between two lists in Excel

During working on Excel you want to check if any particular data of one column matched with another column data or not ? You can easily compare two list data in Excel using few simple tricks. In this guide we have to discuss how to compare data between two lists in Excel. Read More

## How to Identifying Duplicate Values in two Excel worksheets

If you have more than one worksheets in the same workbook and want to search duplicate values in two Excel worksheet. It is too much difficult to search duplicate values in Excel sheet. In this guide we have to discuss quick ways which helps you to identifying duplicate values in two Excel worksheet. Read More

## 3 Ways to find duplicate values on same worksheet – Excel

If is too much difficult to search duplicate values in active worksheet. In this guide we have to discuss 3 quick ways to find duplicate values on same worksheet. If you have more than one duplicate and unique records then you can easily find duplicate values on active worksheet. Read More