Match-Function

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. This dynamic function allows you to reduce the chances of error and improve the capability of VLookup function. 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